Jump to content

Applescript "create new" fp7, related tables


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

Recommended Posts

  • Newbies

Hi there. I am a relatively new AS programmer and also new to FM7. I am trying to get applescript to insert values into various related tables in my database. I cannot figure how to make applescript insert a new record to each of the related tables ... simultanously.

I.e. I have a "product" table a "sale" table and a "notes" table ... ideally to have multiple sales and notes for each product ... (this is a simplified example, its actually with interest rates, exchange rates, etc where the relationship is not as obvious) I would like to insert a new sale for a new product, and add a note explaining where the product is shipped from ...

I have no trouble doing this in other dbms but ... without the benefit of sql commands, I'm a bit lost.

I have one layout with portals to the correct tables, and, if I were going to add records manually, I would do it there ... but I cannot figure out how to make AS work that way ... and should I add one to the "sales" table, which is not the master table, even with defined rules in FMP, how do I get it to actually add to the "product" table which is the master?

TIA.

Link to comment
Share on other sites

This topic is 6996 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
×
×
  • Create New...

Important Information

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