Jump to content

Related Databases


This topic is 7304 days old. Please don't post here. Open a new topic instead.

Recommended Posts

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]

Link to comment
Share on other sites

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.

Link to comment
Share on other sites

This topic is 7304 days old. Please don't post here. Open a new topic instead.

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
 Share

×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.