If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Many Tables - One Form
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. |
#2
|
|||
|
|||
Many Tables - One Form
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. -- Arvin Meyer, MCP, MVP http://www.datastrat.com http://www.mvps.org/access http://www.accessmvp.com "Nanette" wrote in message ... 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. |
#3
|
|||
|
|||
Many Tables - One Form
On Mon, 1 Jan 2007 10:50:00 -0800, Nanette
wrote: 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. 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] |
#4
|
|||
|
|||
Many Tables - One Form
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. "Arvin Meyer [MVP]" wrote: 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. -- Arvin Meyer, MCP, MVP http://www.datastrat.com http://www.mvps.org/access http://www.accessmvp.com "Nanette" wrote in message ... 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. |
#5
|
|||
|
|||
Many Tables - One Form
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 http://I.Am/DougSteele (no private e-mails, please) "Nanette" wrote in message ... 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. "Arvin Meyer [MVP]" wrote: 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. -- Arvin Meyer, MCP, MVP http://www.datastrat.com http://www.mvps.org/access http://www.accessmvp.com "Nanette" wrote in message ... 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. |
Thread Tools | |
Display Modes | |
|
|