Many Tables - One Form

N

Nanette

I'm trying to get a lot of fields from several tables onto one form. There
are also a couple of linking tables involved.

I'd appreciate any help or tricks. Sometimes the links work and sometimes
they don't and I'm not sure why.

What should I be looking for or doing?

I know this question is vague, but I'm new at this and not sure what I'm
doing wrong.
 
A

Arvin Meyer [MVP]

Try linking the table on common field(s) in a query. Have a look at the
design view of one of the queries in the Northwind sample database for an
example of how to do it.
 
J

John Vinson

I'm trying to get a lot of fields from several tables onto one form. There
are also a couple of linking tables involved.

I'd appreciate any help or tricks. Sometimes the links work and sometimes
they don't and I'm not sure why.

What should I be looking for or doing?

I know this question is vague, but I'm new at this and not sure what I'm
doing wrong.
Click to expand...

If you have many similar tables, differing only in the tablename, then
THAT'S what you're doing wrong. Consider having one single larger
table with one additional field to distinguish what are now separate
tables. Data should be stored in tables - *not* in tablenames!

John W. Vinson[MVP]
 
N

Nanette

I've been looking at Northwind and it makes some sence, but I can't find an
example with a linking table.

I've got a linking table that connects the multiple tblCabinet PNs and the
multiple tblParts PNs. I used the linking table to get one cabinet number
with the multiple tblParts PNs on a form. I have another table that holds
other tblPartDetails. What I need to do is have these other PartDetails show
the details for the tblParts PNs on the same form.

Is this possible?

I connected the Master and Child Link Fields to no avail.
 
D

Douglas J. Steele

The Order Details table resolves the many-to-many between the Orders and
Products details.

The Orders form uses the Orders Subform form as a subform to allow updates
to the tables.

--
Doug Steele, Microsoft Access MVP

(no private e-mails, please)
 
Top