1 Reply Latest reply on Feb 23, 2009 11:58 PM by hiatts

    MULTI FIELD RELATIONSHIPS

    beckett85_1

      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?