I am working on a database that is using relational value lists. The list pulls from data in a field based on a table relationship.
A simple example of one:
- staff member
- staff member (value list from table A)
- in process defect code
The tables are linked by company and in table B my list of staff members changes based on my company selection. The problem I am having is that the value list auto-fills the first member of the list once I pick the company. How do I make the value list field remain blank until a user actually makes a selection?
FM Pro 11