Template needed for database w/single input form

[Lykus]

My client wants to have a single input form to input data into several different tables. All of this feeds reports that combine the data entered from the single form in different ways.

I need to be able to see all the data on this form, search any field using the Find/Replace button, use a drop down box to be able to choose values that may have already been entered into a given table, and enter in new values not currently in a given table.

Can anyone direct me to an example of something like this that I might use as a guide?

[MMcCarthy]

My client wants to have a single input form to input data into several different tables. All of this feeds reports that combine the data entered from the single form in different ways.

I need to be able to see all the data on this form, search any field using the Find/Replace button, use a drop down box to be able to choose values that may have already been entered into a given table, and enter in new values not currently in a given table.

Can anyone direct me to an example of something like this that I might use as a guide?

Lykus

There are a number of issues here. Using a form to enter data into multiple tables is not straightforward. Firstly, only the tables that have a one to one relationship can be included in the query for the recordsource of the main form. All other tables would need to be handled using subforms.

Mary