I need help regarding relationships.

[mimran2k2]

A garment style has coded tasks.
Such as a style is 552-327 (trouser)
It has coded tasks.
I made a table 'Style' containing Style-ID and Style#.
I also made a table '552-327' containing one particular style 552-327. Contents Style_ID, SN, Task Desc., and its rate.
Similarly I made a table '600-539' containing particular style 600-539. Again contents are Style_ID, SN, Task Desc., and its rate.

How can I link the Style-ID with the two tables?
Thanks.

[MikeTheBike]

Hi

Why make separate tables?

Just make the a table called Style_Data (or similar) with the Style_ID, SN, Task Desc fields as required and relate it to the style with the Style_ID.

I would also put the Style Number in the Style Table (which where it belongs as I assume this is unique to the style?) and just have the Style_ID the Garment table to relate to the style in the Style table.

That is if I understand what you are tying to do.


MTB