multiple tables - one form

[seltzer]

I have five tables with ID as the join between them. I want to create a form that includes all the fields from the five tables, but I do not want to have to repeat the ID five times on the form. I want the data entry person to enter the ID one time and then enter all the fields associated with one record, filling all 5 tables with data. Is this possible?

Thanks...

[hyperpau]

I have five tables with ID as the join between them. I want to create a form that includes all the fields from the five tables, but I do not want to have to repeat the ID five times on the form. I want the data entry person to enter the ID one time and then enter all the fields associated with one record, filling all 5 tables with data. Is this possible?

Thanks...

yes it is. create a query to combine all those fields from all the 5 tables that you want.

then bind yout form to that query. make sure that there are relationships between the IDs of each table.

[missinglinq]

And with five tables involved, and I'm guessing a bunch of fields, you might want to use a form with tabbed pages, one for each table's fields. This way the input form will be divided into logical groupings and your input form won't be overcrowded.