In my Standard Clarion application I have a situation where a user enters a record. One of the fields is a trip number which has a foreign key parent record. Based on certain criteria the record is either
1.accepted- the waybill number does not exist, or
2. a message saying that the record is a duplicate, reenter or
3. a message saying does the user want to programmatically change the trip number since a waybill with the entered number already exists connected to a different trip.
1. is obviously no problem
2. This code handles it: p_web.Script('alert("This waybill has been delivered.Change the number");')
3. Any advice on how to query the user if he wants to change the trip field and then get back a confirmation which would tell me to either change the trip field of the original record or tell the user to change the waybill number depending on his response