RonaldBiemans
asked on
Relation question
I have the following tables
table1
AssetID (primary key)
Name
table2
CorID (primary key)
AssetIDx
AssetIDy
now I want a relation from assetsIDx in table2 to assetID in table1 AND
I want a relation from assetsIDy in table2 to assetID in table1
how ???
table1
AssetID (primary key)
Name
table2
CorID (primary key)
AssetIDx
AssetIDy
now I want a relation from assetsIDx in table2 to assetID in table1 AND
I want a relation from assetsIDy in table2 to assetID in table1
how ???
SOLUTION
![Avatar of Guy Hengel [angelIII / a3]](https://filedb.experts-exchange.com/files/public/2013/11/25/ddbe0ea6-aa6e-4279-b781-57b735dd3ea0.jpeg){kind=small}
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
gauthampj that works for one but not for both, hence my question
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
PFFFFFFFF, I'm stupid sorry, I had already done what you all suggested and it didn't work because I had another reference (which I didn't mention) set to cascading Update/Delete if I remove that it works.
I'll just distribute the points to everybody that commented, sorry to have waisted your time :=)
I'll just distribute the points to everybody that commented, sorry to have waisted your time :=)
ASKER