Hi,
I know I must be missing something.. I've inherited a dodgy database in that it has ZERO FK relationship information between the tables and fantastically inconsistent tables names. But thats my problem. I am trying to establish the relationships between the important tables e.g.
Table: TopProducts (2 part key: SKU, CATEGORY_ID)
Table: Product (key: SKU)
Table: Category (key: CATEGORY_ID)
I want to establish the relationship between TopProducts table and both Product and Category tables, but within the designer, when setting this up I seem to be only be table to select "Foreign Key Fields" from the one table?
I'm using version 2.6 of the designer, any ideas?