February 22, 2010 at 1:38 am
Hi, I have 10 tables and I need to enter primary key ID of one of these tables into interface table(s) (used as foreign key). In fact, I want to make relations between these 10 tables and the interfece table(s). I have two solutions: 1- assigning 10 interface tables for all tables and insert FK to the related table. 2- creating just one table and insert FK and TableName of all tables into it. which one of them is best regarded to simpleness(in design and making query) and optimization?
Thanks
February 22, 2010 at 7:11 am
I'm not really sure what you mean. Could you post table definitions and an example of what you want? Or a diagram of what you want to do?
Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question
Viewing 2 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply