AutoNumber

[adamquestion]

Hello,

I have a question. I would like to be able to have an autonumber in the main form be applied to text boxes on the subform. So If I enter a name in the main form, an autonumber is generated, then that number is automatically entered into the boxes in my subform. My subform is a datasheet view with many records. I want all the records to have the autonumber generated in the main form. Is there a way to do this. Currently I have the boxes in the subform retrieve the autonumber by setting it equal to the autonumber text box on the main form. I would think that there would be an easier way to accomplish this seemingly simple task.

Thanks,

Adam

 

[MStef]

Fill up LINK CHILD FIELDS and LINK MASTER FIELDS properties.

 

[MStCyr]

The link field in your subtable cannot be Autonumber but rather Numeric and Long Integer

 

[adamquestion]

well, i have several records displayed in a datasheet view form that need to apply to that autonumber. I have linked the tables so that it will "Include all records from .... and only those records from ... where the joined fields are equal" this allows me to view all the items I need to in the form. When I set up the child/master it does not show the records because they do not have that link. Is there a way to send the autonumber to those records so that they will be linked?

 

[MStCyr]

The linking is done thru your subform properties...Link Child Field/Link Master Field. If you have too much difficulty in doing this I could send you a smaple if you wish...let me know ... stcyrm@aol.com

 

[adamquestion]

I open the form and I enter a title and a date. That title and date needs to apply to every record in my subtable. I want to apply that via the ID of the main form. I would like a procedure that once you enter the title and date... the autonumber that is generated automatically fills in the foreign key of the subtable with that ID. So I will have 100 records with that ID. I have set up an append query that adds that to another table. So I can continally enter the database and enter a new title and date and the new ID applies to the 100 products. I would then have several groups of those 100 products that I can recall with just 1 ID.