One form two Tables

K

Kashif Hussain

Help please ... i really need to do on urgent basis ...

i have build a form which is used for data entry but at the back it has to
been linked with 2 tables ... as half of the form data will be saved in the
customer table and other half in application table .....

Please please tell me how i will do this .
 
R

RBear3

How are the tables related? Is this a many-to-many relationship where each
customer can have more than one appliction? If so, you would base your form
on the customer table (or a query built on it) and you would include a
subform with the applications. You can look at the sample database -
Northwind. I believe the order form works like your example.
 
K

Kashif Hussain

thanks for the reply ... but is there any way or any type of query by which i
can do what i wanted ...

when i press the save button ... query runs and save the customer data in
customer table and application data in appliaction table ... i dont want to
use subform .... as i have alreadt designed the form and it has been approved
by my senior ... only this is left .
 
R

RBear3

Probably, but you are missing the point. If your form is set up for one
customer and one application, but you truly have a many-to-many
relationship, then your form is wrong. It does not matter that the look of
the form has been approved if you are going down the wrong path. Assuming
this is a many-to-many relationship, trying to code around a poorly built
form will end up causing you tons of grief down the road.

If this is not a many-to-many, then you will need to give us more detail so
we can help you out.

Note that you can place a subform on your existing form and (if done
carefully) the look of the form will change very little. But, in a
many-to-many your form should probably look different.
 
Top