michelle.peterson

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!

Michelle

 

FM Pro 11

Outcomes