Multi Table Inser Query

K

Kashif Hussain

Hello ... im new to Access so i need some expert help.
im creating an application for my organization where i have this one form in
which i collect all the required data and need to save it in table but the
problem it this form is connected to to different tables.

how can i save the data via query on one click to two different tables ?
 
A

Allen Browne

If you have several tables, each with essentially the same fields, and you
need to connect up your form to different tables at different times, you
have not built a database.

That kind of thing might make sense in a spreadsheet, where you create a
sheet for each one. In a database, you combine those tables into one,
probably with one more field to indicate whatever the difference is (i.e.
what's different between the current tables.)

If you don't want to do that, it is possible to change the RecordSource
property of the form so that it points to a different table. But I could not
recommend that as a solution to what you describe.
 
W

Wayne-I-M

Hi Kashif

Have a look at Allan's answer as iit s good advice (i.e. you seem to have
mixed up Excell and Access).

Not really sure what you are trying to do but (I think by looking at your
post) a simple method would be to create the tables - link them in a query -
base the form on the query. The are 'many' advantages to baseing a form on
a query rather than a table.

Hope this helps
 
K

Kashif Hussain

Allen Browne thank for your reply

i think you didnt got my questions .. i have created a database made the
relationships and i have build a form for it also .... but the problem is i
have one form which is used for data entry and the data inputted in that form
has to be stored in two different tables like in that form i have customer
personal information which i want to be saved in customer table and other i
have customer application information which i want to be stored in
Application table .

i think i have to build a query to do this but i dont know how to make this
query or if you any other idea please let me know .

Waiting for you reply .
 
A

Allen Browne

Sorry my try did not answer your question.

I don't know what else to suggest.

You can create a query, but I'm not sure how you would do it that way, or
what you would do with the query.
 
K

Kashif Hussain

if you could give me you email address i can email you my database i create
for you review that will help you to understand what im trying to ask

my email ID is [email protected]
 
Top