tables

[sgtcwby]

Okay here goes...

I currently have 3 tables

1 table is big list of personnel
The second table is a smaller list of those personnel with maybe a couple
extra columns.
The third table is a table I split off of the 2 table after I did the
analyze under tools.

So now the second table when you bring it up as plus signs so you can click
them and it will bring up the parts of the third table that the rows are
linked to.

I need to somehow combine table 1 & 2 and still have them linked to table 3.

Any help? Thank you.

 

[Arvin Meyer [MVP]]

If tables 2 and 3 are truly linked, it is because of a relationship that is,
or should be defined under Tools >>> Relationships. You should not be
displaying your data in tables. The display is the baliwick of the form or
the report. Tables are for storing data.

While it is possible to view the data exactly like you wish in form
datasheets, it probably is a much better idea performance wise to display a
single record, then use a subform to display its child records. If you
tables get large, you will notice the difference.