Can I use QRY to make a form

  • Thread starter Ronnie O via AccessMonster.com
  • Start date
R

Ronnie O via AccessMonster.com

I have 3 Tables:

EmpData, LicenseData, CategoryTab

I have 5 categories in the CategoryTab for the 5 different licenses I keep
track of for our employees along with expiration dates. The primary key in
the EmpData field is an AutoNumber Field and then I have a Emp ID number that
is also unique that we give to each employee. The Tables are joined on
EmpData Tab EmployeeIDPK autonumber field to LicenseData Tab LicenseID
autonumber field then from LicenseData Tab CATID Field to Category Tab CATID
field.

I need to create a form that allows me to enter all the information for the
First two tables and shows me the 5 license categories with all 5 expiration
dates. I tried doing a subform with a dropdown field in the category field.
But if they have all 5 with expirations I really need a static field showing
the name of the license and then the exp date. Should I just copy the cat
fields and dates 5 times and put it into the subform like that or should I do
a query using the Emp Data and License Data tables, still copy the field 5
times and put it into one form? Please advise.
 
Top