I am not strong in DB administration, so I believe this question might be easier than what I think it is. I need to automate a value on a field when I select a certain field from another database. First of all, the two database I am talking about have a relationship established but on different Fields than the ones I am working on. I am not sure if I need to make another relationship with the fields I am trying to manipulate. In a certain Form I have a drop down list with four options available. When I choose "CA" which is one of the options available in the database called "Quotes.fp5". I want it to populate the value "Completed" in the field "Job Status" in another database called "Projects.fp5". I have an "IF" statement set inside this script.
Insert Text[Select,”Projects::Job Status” = "Completed"]
It does not change the Job Status. Now, the Field "Job Status" in Project.fp5 is set to Auto-Enter Data "Current". So I thought the Insert Text option would do the trick. Do I use the “Set Field” Option to do this? I have been digging at this for the past 3 hours any help would be greatly appreciated.