AnsweredAssumed Answered

A relational question

Question asked by JohnDee on Oct 22, 2013
Latest reply on Oct 22, 2013 by philmodjunk

Title

A relational question

Post

     The main table of my database is Projects, this is related as a child record to Companies which in turn has Representatives_of_Companies as a child table. Within the Project table there are fields that are to be populated via the Companies table, namely Client and Associate_Company (ten fields from 1 to 10).

      

     At the moment the Project table has an fk_client_serial for the Client field but the Associate_Company (1-10) only use a list derived from Companies with explicit relation and pk/fk interchange. 

      

      

     So, my query, is simple. Is this good practise the way I am going about this or is it just an inept way to go about it. 

      

      

     Should I try to create a new TO for Companies and try to relate Associate_Companies?

     Should I just fill Associate Companies with a serial no. (pk) of Companies from the parent table? 

      

Outcomes