Passing data between forms and query

B

bcBoy

Here is the situation/problem:

I got an ACCESS database with tables setup as follows,

TABLE1(Table1_ID,T1_f1,T1_f2,T1_f3,..)
TABLE2(Table2_ID,Table1_ID,T2_f1,T2_f2,T2_f3,..)
TABLE3(Table3_ID,Table1_ID,T3_f1,T3_f2,...)

What I need is to setup two forms (FormA & FormB), FormA contains TABLE1 &
TABLE2, and FormB contains TABLE1 & TABLE3. When I am working on FormA, there
is a button in FormA for user to click-on and then will open FormB. Since 3
Tables got the same Table1_ID as linkage, how can I make this Table1_ID pass
to FormB and do the query automatically and display the default in FormB?
(i.e. Both FormA and FormB will display some of the field values in TABLE1)

I am new in Infopath and I am not a programmer either, PLEASE HELP!!!
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top