AnsweredAssumed Answered

MULTI FIELD RELATIONSHIPS

Question asked by beckett85_1 on Feb 23, 2009
Latest reply on Feb 23, 2009 by hiatts

Title

MULTI FIELD RELATIONSHIPS

Post

JUST A QUICK QUERY, I HAVE A TABLE WITH A coach and an assistant in it, whilst i have another table with a pay rate in it, when i have the column coaches pay and assistants pay, where coach gets double pay and assistant gets single pay, i want it to look up this table and give me the result unfortunately when i do the database gets confused because there are 2 columns looking up the one related data base any ideas?

Outcomes