Relationship HELP

[Parmb]

I'm creaing an IT D.Base cataloging the IT equipment.
Problem is i've a super class table called 'computer' with comp_ID as pk, then i have the tables

'laptop' pk - lap_Id, fk - Comp_ID

'desktop' pk - desk_ID, fk - Comp_ID

when i test the system it wont let me add a desktop as it requires a related record in the laptop table. How do i set the relasionship from 'must be' to 'may be'.

any Help will b apreciated.

 

[jebry]

Hi!

Maybe you could keep all of the information in one table and just have a field which identifies the computer as a laptop or desktop. If not, I would recommend that you get rid of the lap_id and desk_id and use the Comp_id as the pk in all three tables. That way Access will realize that you have a one-to-one relationship and will not give you problems. Finally, check again how you set up the relationships, both the laptop table and the desktop table should be related to the computer table, but not to each directly. If that is how it is set up then you shouldn't be having troubles.

hth Jeff Bridgham
bridgham@purdue.edu

 

[Zeroanarchy]

ok, my advise is get rid of the following, the subtract, underline and the word id. All three of these are used for diffrent purposes in Access, If you start using them know you are going to have no end of problems later.

Zero Anarchy