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
|
|||
|
|||
Confusion with forms and related subforms
Hello,
I'm trying to figure out the concept of embedding subforms into main forms. I have main tables, 4 junction tables, and a few look-up tables (not all look-ups are listed below). If I'm reading it correctly, the junction tables which relate to the main tables should be in the form of a subform placed within the main form they relate to? I'm lost on the fact that I believe I have a subform which appears should be on another subform which should then be on a form. If this is correct, the form looks extremely busy and not user friendly, and just plain incorrect. Is it true, based on the relationships, that the PK and FK on the related tables should be joined between the subform and main form? These are the tables I have: TblIncident IncidentnumberID (PK) misc. fields TblSuspect SuspectID (PK) misc. fields TblOfficer OfficerBadgeNumberID (PK) OfficerLastName OfficerFirstName TblIncidentOfficer IncidentOfficerID (PK) IncidentNumberID (FK) OfficerBadgeNumberID (FK) TblIncidentSuspect IncidentSuspectID (PK) IncidentNumberID (FK) SuspectID (FK) TblIncidentSuspectCharges IncidentSuspectChargesID (PK) IncidentSuspectID (FK) ChargesID (FK) TblForceUsed ForceUsedID (PK) OfficerBadgeNumber (FK) TypeofForceID (FK) TblCharges ChargesID (PK) Charges Thanks in advance for any assistance. |
Thread Tools | |
Display Modes | |
|
|