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

    More than one relationship between two tables



      More than one relationship between two tables




      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.