RachelMiller
4 years agoQrew Cadet
Choices For Selection Field/Look Up Fields
I apologize in advance for how I try to explain my scenario but hopefully someone can help.
I have 2 tables in my app with a relationship set up. "Sites" and "Extracts" with Sites being the parent table. When I enter a record on the Extracts table, I want field Health System to be the field I select from and 5 other fields from the Sites table to populate based on my selection. This is working except that the Health System field is populating with a choice from a different field until I save the record. I've attached a document showing what is happening. I also want the selection list to show different fields in the selection box.
I hope this makes sense and the attachment shows enough details.
------------------------------
Rachel Miller
------------------------------
I have 2 tables in my app with a relationship set up. "Sites" and "Extracts" with Sites being the parent table. When I enter a record on the Extracts table, I want field Health System to be the field I select from and 5 other fields from the Sites table to populate based on my selection. This is working except that the Health System field is populating with a choice from a different field until I save the record. I've attached a document showing what is happening. I also want the selection list to show different fields in the selection box.
I hope this makes sense and the attachment shows enough details.
------------------------------
Rachel Miller
------------------------------