I have some custom tables of products which belong to the links and I'm a bit stuck with joining tables.
I have set a foriegn key relation between ID in the Links table and LinkID in the custom table. However, when I want to select products from the custom table that are in a specific category, I want to select from (Custom, CatLinks) with the join on LinkID. I have this set up as a foreign key relation but I don't think this is a good idea as I don't want anything deleted from the CatLinks table when I delete products from the Custom table or vice versa. I suppose that I could do the select on (Custom,Links,CatLinks) but this seems a bit of a waste.
Is there a Links command to join two tables which don't have a foreign key relation?
Thanks, Laura.
I have set a foriegn key relation between ID in the Links table and LinkID in the custom table. However, when I want to select products from the custom table that are in a specific category, I want to select from (Custom, CatLinks) with the join on LinkID. I have this set up as a foreign key relation but I don't think this is a good idea as I don't want anything deleted from the CatLinks table when I delete products from the Custom table or vice versa. I suppose that I could do the select on (Custom,Links,CatLinks) but this seems a bit of a waste.
Is there a Links command to join two tables which don't have a foreign key relation?
Thanks, Laura.