Form / subform and record junction table
Can you have a form with a subform and have both bound to the same table? I have a junction table for entering equipment issued to an employee. I want the header of the form to have a combobox to select the employee and I want the subform to view the equipment issued and be able to add new records. I had it working... sort of, it would open and generate a duplicate record that would force me to go into the transactions table and delete it to be able to go back and open it... Not exactly sure why, unless there was something on the way the form opened... Any Ideas on how to make this work.. I am mainly looking at the layout of the form... I like the one Employee Combobox on top and then a continuous form below made to look like a datasheet that I can add/edit.. . Tables are:
Edit.. I don't want the Employee name to be recreated for every transaction record... Which is why I attempted the form/subform look.
Employees
EmployeeID (pk)
Equipment
EquipmentID (pk)
Transactions
TransactionID(pk)
EmployeeID (fk)
EquipmentID (fk)
TransactioDate
QtyIssued
Thanks.