Subforms and Linking Help

  • Thread starter Thread starter mds11
  • Start date Start date
M

mds11

Hello,

I am designing a jail management application and need help creating/
linking subforms for the user to enter data. Here are my tables:

Inmate (one) ----> Arrests (many)
Arrest(one) -------> Offenses (many)

Is there any way for a user to input this information in one form with
several subforms, or do I need three separate forms? I am trying to
simplify things for easy user input. Any insight will be greatly
appreciated.
 
For each level of relationship, the (many) table(s) need to have the key
value for the preceeding table. That's how you link the (bound) subforms to
main forms.
 
Back
Top