⚠ In case you've missed it, we have migrated to our new website, with a brand new forum. For more details about the migration you can read our blog post for website migration. This is an archived forum. ⚠

  •     

profile picture

N-N relations with hierarchied tables.



Bobby

Bobby
  • profile picture
  • Member

Posted 29 September 2015 - 15:55 PM

Hello,

 

Thanks for the possibility.

 

I have been looking for a way to access a column related to the foraign key in a table that is part of an n-n relation. The problenm is that this table is a child of other table thas is the one that has the atribute I need. How can I access this atribute, that is not inside the directly related table, and show it in the drop down list of the drid that is created by the n-n relations?

 

Very much thanks (Sorry if my english is wrong... I' chilean).


titu

titu
  • profile picture
  • Member

Posted 01 October 2015 - 02:34 AM

Hi,

 

It's no very clear. Perhaps you can attach the database schema.

 

One idea would be to create a view? did you try? Maybe schema is not well done?