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.