21 Oct 2012 at 22:14 #1 mattux mattux Associate Joined 17 Oct 2002 Posts 312 Location herts hi i have 3 tables clients client_id jobs job_id client_id contacts contact_id contact table can be of client or job where do i put the forien keys to link both clients and jobs to contacts please
hi i have 3 tables clients client_id jobs job_id client_id contacts contact_id contact table can be of client or job where do i put the forien keys to link both clients and jobs to contacts please
21 Oct 2012 at 23:13 #3 mattux mattux Associate OP Joined 17 Oct 2002 Posts 312 Location herts thanks pho I split the tables.