How do I add multiple fields in the same table with the same primary key?
For example I have an employee with the employee ID 1 named john. He has two degrees. One in Math the other in science. I need to have both of these incorported into my table.
Novice
Windows 7 32bit 
Access 2010 32bit
How do I add multiple fields in the same table with the same primary key?
For example I have an employee with the employee ID 1 named john. He has two degrees. One in Math the other in science. I need to have both of these incorported into my table.
Who is John Galt?
Windows XP Access 2007
Typically that would be represented with another table, related one-to-many on the employee ID. The employee would have a record in that table for each degree.
Novice
Windows 7 32bit Access 2010 32bit
Thank you! That worked.
Who is John Galt?
Windows XP Access 2007
Averages in Access query based on fields in multipleobjects and multiple date fields
Posting Permissions
Reply With Quote