Hi,
I am working on a database of the inventory of PC-Hardware and Software. The hardware is basically divided into PCs and Displays both of which will have a seperate table. Each PC and each Display should have an InventoryID (which Access will automatically assign) but an InventoryID may only be assigned to either a PC or a Display.
So I created an InventoryID table which is linked to both the PC and the Displays tables ina 1:1 relationship (by having the InventoryID be a primary key in all three tables). The problem now is that an InventoryÍD can be assigned to both a PC and a Display.
Is there any way to get Access to only allow every InventoryID to be linked to either a PC or a Display but not both? Or is there even another way to solve this problem without combining the PC and the Display table?
Thx
I am working on a database of the inventory of PC-Hardware and Software. The hardware is basically divided into PCs and Displays both of which will have a seperate table. Each PC and each Display should have an InventoryID (which Access will automatically assign) but an InventoryID may only be assigned to either a PC or a Display.
So I created an InventoryID table which is linked to both the PC and the Displays tables ina 1:1 relationship (by having the InventoryID be a primary key in all three tables). The problem now is that an InventoryÍD can be assigned to both a PC and a Display.
Is there any way to get Access to only allow every InventoryID to be linked to either a PC or a Display but not both? Or is there even another way to solve this problem without combining the PC and the Display table?
Thx