I have a set based on primary table with Insurance Customer Information. Naturally each customer can have multiple policies. So on a main page I have the customer's basic info with a Customer ID.
Also, I have an embedded browse from a 1-many link that links the customers policies to the contact through the contact id field. This browse shows each policy assigned to a given contact.
Each child link record has a unique identifier called policy_id. This field, right now, is placed on the embedded policy list browse.
What I want to do is open a 1-many child form where the data in the child form is based on the unique policy_id found on the browse or through the same field hidden on the main form. This form would show varied information, which includes all the changes that can be made to a single policy record (policy_id). In other words a single policy can have a multitude of changes and each with different information from others. So this information is setup as a child link of the policy child link
I have tried multiple methods (Using Action Scripting) to open the child form with detailed information about the policy buit to no avail. Every method of filtering to the proper policy has failed each time giving an error of "No records found in query". Simply put, I cannot figure out what is preventing the opening of the form correctly.
So maybe some smarter eyes than me can tell me what is the best way to do this using Action Scripting.
Hopefully the attached images can show what I am talking about. I know this probably confuses those who are really sharp with X-Basic but don't have a clue about what I have in my mind
I did notice in Alpha Sports there was no summary form/screens for individual customer purchases without digging through invoices.
Also, I have an embedded browse from a 1-many link that links the customers policies to the contact through the contact id field. This browse shows each policy assigned to a given contact.
Each child link record has a unique identifier called policy_id. This field, right now, is placed on the embedded policy list browse.
What I want to do is open a 1-many child form where the data in the child form is based on the unique policy_id found on the browse or through the same field hidden on the main form. This form would show varied information, which includes all the changes that can be made to a single policy record (policy_id). In other words a single policy can have a multitude of changes and each with different information from others. So this information is setup as a child link of the policy child link
I have tried multiple methods (Using Action Scripting) to open the child form with detailed information about the policy buit to no avail. Every method of filtering to the proper policy has failed each time giving an error of "No records found in query". Simply put, I cannot figure out what is preventing the opening of the form correctly.
So maybe some smarter eyes than me can tell me what is the best way to do this using Action Scripting.
Hopefully the attached images can show what I am talking about. I know this probably confuses those who are really sharp with X-Basic but don't have a clue about what I have in my mind
I did notice in Alpha Sports there was no summary form/screens for individual customer purchases without digging through invoices.
Comment