A single Contacts Table but with Multiple Roles
Rather than set up contact related fields for customer, supplier and partner tables. I would like to create a single Contacts table and then assign roles to each person within it.
Fred Bloggs, Billing contact at Bloggs Engineering
Dave Jones, Supplier contact for Jones Products
Joe Smith, Partner contact for Smith Industries
Simon Parker, Site contact for Parker Pens
Can anyone point me to a sample file that handles this sort of set up?