Form Trouble

[GarageFlower]

Hi there

At work been given a broken database to fix

Basically we are using three tables to make a query

We then want to use that query to supply a form to input information into the tables. Sounds simple enough eh?

These are the fields we are using from the tables

Table1
TLB
Department

Table2
Output Table Reference
Output Title
Information Group Name

Table3
Data Definition
Data Equivalence Number
Data Equivalence Rating

These fields from the tables supply into a query which we have made into a form.
All working well

Right then what we want is to be able to enter new records with this form as well as display the ones allready there.
When we enter the new one we want to have drop down boxes
for following fields
TLB
Department
Output Table
Output Title
Information Group Name

Except we cant seem to be able to do this

Any ideas people