reference field for reusable list?

[annemi]

I want to create a manual list field, and repeat that list in several fields
in the form for users to rank selections (1st choice, 2nd choice, etc). If I
change the list entries in the base field, I want them all to change. It
sounds like I need to create a reference field, but that just creates a
duplicate field that refers to itself. How do I get 5 fields to all refer to
a single reference field? And what is a reference field for if it can only
refer to its own duplicate?

 

[Adam Harding]

Use an access table as the list for the drop-downs, one instance multiple uses.

On your drop-down go into properties select 'look up values in a data
connection to a database .... etc. And go to your data connection select the
table you want, then the field and voila.

Hope this helps

 

[Franck Dauché]

Hi,

If you don't want to carry an access database around with your form, your
can achieve the same with a secondary data source, which will be embedded in
your form (easier to distribute).

Regards,

Franck Dauché