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
|
|||
|
|||
Relationships: Main and detail
I am having trouble figuring out how to relate a number of tables. I have a
Main Table Compl_Main that will end up also being my Main form (Unique ID: Compl_ID) I have a Detail Table Detail_Main that I will be putting into a subform (Unique ID: Det_ID). These two tables have a one-to-many-relationship. I set up a field called UWI_Link Our company has a Corporate Hierarchy that I need to tie into on the detail level and it consists of two linked tables. Table: UWI_POINTS this contains the UWI which is the field that will be unique as well as fields: Location_ID and Location_Name which I also need to display Table: UWI_CORP this contains other fields such as District, SubDistrict, Area that I also need to display and is linked to UWI_POINTS by Location_ID Currently, I have set up a One-To-Many Relationship with UWI_Link in Compl_Detail and UWI in UWI_POINTS What I need is for the User to type in the Header info on the form and in the subform type in the UWI (or select from drop down) and have all the other fields fill in with the correct data. The user will then have some other fields to fill out. How do I get all these fields from the two UWI tables to fill in? Thanks! |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
header of main report and detail (subreports) splitting | jenn | Setting Up & Running Reports | 0 | December 30th, 2004 04:40 PM |
Duplicating Main Form And Its Subform Detail Records in Access 97 | bdehning | General Discussion | 3 | August 25th, 2004 12:33 AM |
Problems totalling subreport data on main report (A-2002) | Marshall Barton | Setting Up & Running Reports | 0 | June 23rd, 2004 08:01 PM |