Hi all. I am hoping for some help. I have spent several days trying to connect four tables. I can not get the forth table to work. I need tblInventoryMaterial to work with tblInventoryTime. I have tried linking them using a control (ctrlLinkTimeAndMaterial) using various fields in tblInventoryMaterial . I need to have several records in tblInventoryMaterial to match one record in tblInventoryTime. There are 3 crews so each crew will have material each day. I hope this is enough info for you. Below is a screen shot of the relationships. Thank you in advance.