adding information from two seperate tables into one form/.

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have two tables, and dont want to make the relational. I need to add the
fields from each table to the form, which has two tabs. please help me~!
 
If they are not related, how would you know which record to display on each
tab?

You can do this, by putting two separate subforms on your unbound form. In
the subform data source for one form, put the first table. In the data
source of the second, put the second table. I've not tried this, but it
should work. Of course you'll have to have a method to select which record
to display in each tab.

This sounds odd. You might want to post a few more details. If your table
design is not normalized, you could be in for tons of headaches down the
road.
 
terd said:
I have two tables, and dont want to make the relational. I need to add the
fields from each table to the form, which has two tabs. please help me~!
Click to expand...


That's a pretty vague request so I'm not at all sure what
you need. How about using a separate subform for each
table?
 
Back
Top