Relational Value Lists

Discussion created by michelle.peterson on Jun 25, 2012
Latest reply on Jun 26, 2012 by michelle.peterson

Hi everyone,

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:

Table A

- company

- staff member


Table B

- company

- 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?


Many thanks!



FM Pro 11