Double relationship ?

[LMichel]

Hello,

I'm not a database expert and here is a problem that I can't solve !
Consider these 3 tables:


tbl_Item ('Item_ID', Content_type, Content_ID)
tbl_Type1_Descr('Descr_ID', Property1, property2)
tbl_Type2_Descr('Descr_ID', Property3, property4, property 5)

An Item can have a different description according to his type.
How can I tell access to search a description in one table or in the other according to type.
If there was only one type, I should link Content_ID with Descr_ID. But in this case, can I link Content_ID with Descr_Id in both description tables ?

Thanks for helping me !

 

[Aivars]

Yes, you can!

How I understood you already have relationships between tbl_Type1_Descr.Descr_ID and tbl_Item.Item_ID

Add your table tbl_Item once more as tbl_Item_1 (default name) and create relationships between tbl_Type2_Descr.Descr_ID and tbl_Item_1.Item_ID

Aivars