You want to set the field ID, but you didn't tell it what to set it TO.
Is that the only issue?
Table 2 (main table):
I only have Kf_ID that is related to the Notes table, no other fields are related
As for script, I have:
Set Variable [$ID_Contact; Value:Contact Management::k_ID_Contact]
Go to Layout ["Notes_Utility" (Notes)]
Set Field [Notes::kp_ID ; $ID_Contact ]
Commit Records/Requests [Skip data entry validation; No dialog]
Go to Layout [original layout]
Go to Field [Notes::Text]
Thank you, but its still not working. I have a relationship from Contact Management table to my main table as "kp_ID_Contact" to "Kf_ID" and then for my Notes table I have the relationship from "Kp_ID" to my main table's "Kf_ID". I have no other relationships.
I do not use anything from the Contact Management table, I only have it in hopes to get the script to work.
Right now, when I click the "add note" button (with that script above) it doesn't do anything. If I move it out of the portal it still doesn't do anything, I cannot even click on it and type stuff manually. If I put it in another tab it will send me to my first tab when I click on the "add note" button. I am soooooo confused!
I made the name kp_ID and kf_ID, so does that make it a key? or do I have to click something to make it a key? and Kf_ means that it is the "main key" while the Kp_ makes it the key for that table but secondary to the main key?
Thats the only thing I can think of that is messing up this function I am doing... relationships.
Is Kp_ID in table 1 defined as an auto-entered serial number? If not, it should be.
(Any field is a "key" field if it is used to link two tables in a relationship. The name given has nothing to do with that. If you see it on the end of a relationship line in Manage | Database | Relationships, it's a key)