Creating a new table with relation via script

[DieHoelle]

Hi,

I'm trying to find a way to create new tables with a relationship to my existing db using a script.

The point is that I have a table "parts" and a lot of distributurs which are selling the parts. I want to link the new table f.e. called "distr1" to the table "parts". The user can should chose the related field in the "distr1" table which will be related to the primary field in the "parts" table.

Any idea, of course a plug-in?

Thanks a lot,

Chris

[Vaughan]

No, you cannot do this. And you dont want to either. It's very poor data design.

What you need is something like a Distributors table that has a record for each distributor. This distributor record then gets related to the parts records.

[DieHoelle]

I think you are right.

I have build a table to import data from every distri I have and assign a "IMPORT_ID" for every import the user does. So I can recover every import for the user and everythink is fine.

Thanks for the brainstrom

Chris

[omegagoh]

Dear DieHoelle,

If I didn't misunderstand you. A part may be sold by many distributors and a ditributor may sell many parts.

If it is the case, then you have a so-called many-to-many relation. A common practice to resolve such problem in relational design is to create a join table, say DistributorPart that contains both keys from Distributor and Part table.

Best regards,

Omega Goh

The FileMaker Specialist

Speedy Scaleable Solutions