Afternoon,
Looking for some advice, guidance and direction on the following.
I am looking to have a singulart look up against a table. Based on the value returned, populate several widgets with data from that look up.
Exmaple belwo
1. Lookup against 'customer_account' allow user to select account record
- Return account.facility_id based to be used in below widgets
2. Widget 1 :Based on the above returned value account.facility_id
Return data from record on 'x_facilities' with matching account.facility_id
HTML Table to display reference fields on that record
8 reference fields needed to be displayed in a table
3. Widget 2 : Based on the above returned value account.facility_id
Return data from record on 'x_facilities' with matching account.facility_id
HTML Table to display reference fields on that record
6 reference fields needed to be displayed in a table
4. Widget 3: Based on the above returned value account.facility_id
Return data from record on 'sn_customerservice_team_member' with matching account.facility_id
These are users records and are just data in that table
Any guidance in how to accomplish this, would be greatly appriciated.
Thank you!
