I am trying to use a subform for data entry but I have four Primary Keys and there are only three spaces in the Linkchild/LinkMaster. This creates an error since the relationships are defined between these two tables based on four Primary keys. What can I do? Any help appreciated.

I should have tried harder before I asked. I found the answer. In case anyone else has this problem.

Even though there are only three categories if you click on the build button next to the field, once you fill in those three and go back to the properties menu. What you actually see in the field is this:

LinkChildFields FirstCriteria;SecondCriteria;ThirdCriteria
LinkMasterFields FirstCriteria;SecondCriteria;ThirdCriteria

All you have to do is click at the end and add another criteria

ie

LinkChildFields FirstCriteria;SecondCriteria;ThirdCriteria;FourthC riteria

LinkMasterFields FirstCriteria;SecondCriteria;ThirdCriteria;FourthC riteria


Thanks