AnsweredAssumed Answered

More than one relationship between two tables

Question asked by hspiegl on May 27, 2010
Latest reply on May 27, 2010 by hspiegl

Title

More than one relationship between two tables

Post

Hi,

 

My Job Management database has the main job specification table along with a table of suppliers (supplier name; supplier address1 etc.). The suppliers could be material supplier (material supplier name) and also a subcontractor (subcontractor name) therefore I need a relationship between 'material supplier name' and 'supplier name along with 'subcontractor name' and 'supplier name'.

 

Whilst I can establish two relationship it doesn't appear to work as an additional lookup.

 

I hope that I have explained this fully.

 

Any thoughts? I didn't want to establish a separate table 'subcontractors' as they are all classed as suppliers in our accounting software.

Outcomes