Foreign Key

[farhaaad]

Dear all,

I m stuck in assigning foreign keys to a primary key.
I have a primary table with many foreign keys, for example, I have a
primary table (ID, Category(pk)) and each category has its own table
because each category has its own feilds and if i make one table for
all categories, there, some fields will be blank for some categories.
When I create relationship between the primary and child tables, it
works. But Now, when i open the primary table and want to expand for
the category information it asks me to choose master and child fields
and i can only choose one table as a child table (subdatasheet).

HOW CAN I VIEW ALL THE CHILD TABLES AS A SINGLE SUBDATASHEET?

I hope you people got the

thank you people in advance

farhaad,

[storrboy]

On Apr 10, 3:48 am, [e-mail] wrote:

Dear all,

I m stuck in assigning foreign keys to a primary key.
I have a primary table with many foreign keys, for example, I have a
primary table (ID, Category(pk)) and each category has its own table
because each category has its own feilds and if i make one table for
all categories, there, some fields will be blank for some categories.
When I create relationship between the primary and child tables, it
works. But Now, when i open the primary table and want to expand for
the category information it asks me to choose master and child fields
and i can only choose one table as a child table (subdatasheet).

HOW CAN I VIEW ALL THE CHILD TABLES AS A SINGLE SUBDATASHEET?

I hope you people got the

thank you people in advance

farhaad,

Data being put into a single field should not come from more than one
table. You can't relate a field to more than one other field in one
other table. It sounds more like you need to re-think the design of
your tables. Perhaps an idea of how you've structured them could help
someone point out a better way to do it. Otherwise do some reading on
normalization and see if you can modify them to work better for you.