Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
How can I create a form that will enter data to multiple tables?
- Thread starter Teaa
- Start date
braindead2
Technical User
you were not real descriptive on your tables but based on what you have said there are several options
1 a single query based on the tables then the bound from based on the query
2 Using subforms based on the other tables
3 changing the recordsource of the form to the tables and manipulating the field names
4 using an unbound form and either ADO, DAO or SQL to manipulate the tables
5 use a temporary table to hold the data then update the other tables from the temp table
Just to name a few
1 a single query based on the tables then the bound from based on the query
2 Using subforms based on the other tables
3 changing the recordsource of the form to the tables and manipulating the field names
4 using an unbound form and either ADO, DAO or SQL to manipulate the tables
5 use a temporary table to hold the data then update the other tables from the temp table
Just to name a few
FunkyMonkey
IS-IT--Management
Is the data in the two tables you intend updating from the same form related?
If yes, and the child-parent relationship has already been determined, run the form wizard adding the appropriate fields from both tables. The relationship will be reflected in the presentation of your form - A main form and subform child-parent relationship will have been established.
If no, that the data is not related, that you simply wish to present all of the information on one form, the process is quite simple. Create a form for one table, then create a separate form for the other table. Create a main form in design view - not running the wizard. Bring this form window size to 'Restore' and drag the other forms you have created into the new form. Change the design of these new "unbound" subforms for presentation.
Hope this helps,
Da monkey
If yes, and the child-parent relationship has already been determined, run the form wizard adding the appropriate fields from both tables. The relationship will be reflected in the presentation of your form - A main form and subform child-parent relationship will have been established.
If no, that the data is not related, that you simply wish to present all of the information on one form, the process is quite simple. Create a form for one table, then create a separate form for the other table. Create a main form in design view - not running the wizard. Bring this form window size to 'Restore' and drag the other forms you have created into the new form. Change the design of these new "unbound" subforms for presentation.
Hope this helps,
Da monkey
- Status
Similar threads
- Locked
- Question
- Locked
- Question
- Locked
- Question