Access form

[edwardcga]

I am trying to create a user form with sub form using the form wizard. I have only 2 tables, Employee (main table) and Vacation (subform table). I pick the fields from Employee Table then fields fro Vacation, but the wizard treat the Vacation as main form and Employee as sub form. I am not sure what I did wrong, please help.

ED

 

[GinaWhipp]

Sounds like a Relationship issue, how are those two tables related to each other? Ie: tblEmployee-EmployeeID (PK) to tblVacation-EmployeeUD (FK)...

 

[edwardcga]

The link is EMP_ID in Employee Table to EMP_ID in Vacation Table.

ED

 

[SteveH2508]

The link is EMP_ID in Employee Table to EMP_ID in Vacation Table.

ED

Which one is set as the Primary Key?

 

[GinaWhipp]

Thanks Steve! That would have been my next post...