Newbies civan93 Posted February 1, 2005 Newbies Share Posted February 1, 2005 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 More sharing options...
This topic is 6626 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
Already have an account? Sign in here.Sign In Now