2 tables 1 form with out a sub form

  • Thread starter Thread starter Sean
  • Start date Start date
S

Sean

I am trying to create a form where I can look up the command and enter the
personnel. I don't know why this is so hard. I would apreciate any help. I
am using office 2003

TBLHSTPersonnel:
HSTNameID - Auto
HSTCommand - Number
Rank
Last Name
First Name
MI
Ect...

TBLCommand:
CommandID - Auto
Command Name
UIC
POC
POC#

Thank You!!!
 
Hi Sean,

What is the relationship between HSTPersonnel and Command? Is it a
one-to-many (1:M) like this:

A person can be in many commands

or, is this correct:

A command can include many personnel

or, do you possibly have a many-to-many (M:N) relationship between these two
tables (ie. both of the 1:M relationships above are correct).


Tom Wickerath
Microsoft Access MVP
http://www.accessmvp.com/TWickerath/
http://www.access.qbuilt.com/html/expert_contributors.html
__________________________________________
 
Back
Top