Search results

How exactly should one go about doing something like this? Thought I would ask..I have the exact same problem. I am trying to join the CustomerName with the CustomerPK. But it looks like if I do that, I will need to re-establish many of the relationships to look at the join query and not the...

OK, Here is my issue: CustomerTable: PK:CustomerName AgreementTable PK:[Lookup]CustomerName from Customer Table:Agreement# AddendumTable PK:[Lookup] Customer Name:Agreement# from Agreement Table So, Each customer may have more than one agreement. Each agreement may have more than one...