queries from one field to two or more tables

[mohsin via AccessMonster.com]

Hi all

Need your help please,
In one table, i have one field which have 2 or 3 values which will refer to
different table (one to many). When queries, the statement will a bit longer
and take a high of processor usage. Or sometime get the errors.

Can you advise my how to prevent this situation please, or may be, i make a
wrong step.

thank you

 

[Arvin Meyer [MVP]]

Your design is incorrect. The rule that you must think of is:

One value in the intersection of one row and one column.

The ONLY thing allowed in one table, that refers to another table is a
Foreign Key which is the Primary Key in the other table. Queries are used to
join the data.

 

[mohsin via AccessMonster.com]

Thank you,

Your design is incorrect. The rule that you must think of is:

One value in the intersection of one row and one column.

The ONLY thing allowed in one table, that refers to another table is a
Foreign Key which is the Primary Key in the other table. Queries are used to
join the data.

Hi all

[quoted text clipped - 10 lines]

thank you