Related Databases

[mad_mickey]

I have two databases that need to be linked or related. My first and main database is a BOM (Build of Materials) database which needs to be linked to a second database which has all the costings of the different parts which make up the product. The problem is that the costings database does not have any directly linked information as it is just basically a comprehensive list of prices (2000+ records). As a result I need a script which says;

if Supplier in BOM database = Supplier in Costings database

and

Part in BOM database = Part in Costings database

(there could be more than 2 variables involved!)

then

copy cost from Costings database to BOM database

Is it possible to set a script up to for this directly in Filemakers Scriptmaker?

[email protected]

[Kurt Knippel]

There are many ways to do this and none of it involves Applescript, which is why I moved it out of that forum.

You can do this with a script that does SetFields, you can do this with calculated fields, you can do this with lookups.

Without a specific or more detailed description of your needs, I cannot even begin to explain how best to accomplish your question.

[Garry Claridge]

You could look at using 'Define Relationships' and 'Portals'. You may be able to use 'Calculation' fields to construct key fields for relating the BOM to the Costings table/Database.

Hope this helps.

Garry