Hi all,
I'm having trouble linking two of my tables using a Link Table. I've attached some screenshots to show how they are supposed to link. One is the 'Orders' table and the other is the 'Competitor' table.
As you can see by the first image (FK_Calendar), I have pulled in the date from the competitor table and assigned this as FK_Calendar. This is also how FK_Calendar is assigned in the Orders table. However, the tables do not link in the main application. The other attached images show the data model, the Link Table, and a group of list boxes. The list boxes show that, even though SKU is associated with Competitor, Orders are not pulled through, despite SKU being associated with orders.
Anyone know what I can do?
Cheers.
