2 tables 1 form with out a sub form

[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!!!

 

[Tom Wickerath]

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
__________________________________________