4 Replies Latest reply on May 27, 2010 8:45 AM by hspiegl

    More than one relationship between two tables

    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.