Hi,
I need to create Access tables for migration.
One user can have multiple laptops.
Is this the best way to create the tables as shown below. (PK – primary key & FK – foreign key)
Table 1: User ID(PK), User name, Email, Contact, Comments
Table 2: Laptop ID (PK), User ID (FK), Location, Desk, Make, Migration Date, Migration Status
Can I create a query to join these two tables together so I can use the table view to enter the details ?
Please assist