I have a series of three pages. a list of patients,... for each patient selected a list of visits... and for each visit selected a list of treatments. I decide to let the user enter new records in-line at the top of the list. All works well except when I need to add a new visit record. I cannot autopopulate the key of the parent to the new record. If I want to add a new visit, I must enter the key of the patient. Obviously the user should not be entering this field (or even see it). I cannot populate this field with the parent's key value and thus the insert fails. The value of this Patient ID field is passed as a parameter when the patient is selected from the previous page.
My apologies that it is in Spanish - but you can see it is complaining that the PatientID that will be associated with this record does not exist. The user should not be typing in this value. By the way, I have the free version of Caspio - I am currently trying it out. Some things are limited (like no Trigger Actions)
You can post now and register later.
If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.
Question
PhilR
I have a series of three pages. a list of patients,... for each patient selected a list of visits... and for each visit selected a list of treatments. I decide to let the user enter new records in-line at the top of the list. All works well except when I need to add a new visit record. I cannot autopopulate the key of the parent to the new record. If I want to add a new visit, I must enter the key of the patient. Obviously the user should not be entering this field (or even see it). I cannot populate this field with the parent's key value and thus the insert fails. The value of this Patient ID field is passed as a parameter when the patient is selected from the previous page.
My apologies that it is in Spanish - but you can see it is complaining that the PatientID that will be associated with this record does not exist. The user should not be typing in this value. By the way, I have the free version of Caspio - I am currently trying it out. Some things are limited (like no Trigger Actions)
Link to comment
Share on other sites
1 answer to this question
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.