I have designed a data base with File Number & File Details Tbl. File Detail Tbl is linked with Fiel Number TBl with Field name File Number. I have also in Field in File Details Tbl as Sr No.
I want in Sub Form i will get a default incremental increase for a particular File Number.
Can i body suggest me to the same.
Thankx in advance.
If you are asking how to have the file# field increase by one every time a record is added to the table then set the feild as Autonumber for the data type. Though i doubt this is what you want....try rewording your request to make it more understandable....sorry.