I’m a ScriptCase newb* and as much as I love the platform, the lack of engagement on the forum is disappointing. I hope someone can help me figure out how to set a session and pass a primary key from one app to the foreign key in another.
Here is my situation: My client searches for or adds a new customer in the “Customer” app. Each customer has a field “pk_customer_master” which is the Primary Key. I have set up a dependency and the relationship is built in SQL.
I want to create a button that creates a new record in the Scriptcase “Calendar” app and insert the “pk_customer_master” value into it “fk_customer_master” field I’ve created in the Calendar app. I can’t figure out a way to create a regular dependency in “Calendar” FYI
*On a scale of 1 to 10 I’m a 4 on MySQL, a 6 maybe 7 on PHP and a 3 maybe 4 on Java/Jquery and Ajax.