reference field for reusable list?

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

annemi - 12 Oct 2005 12:07 GMT

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?

Reply to this Message

Adam Harding - 12 Oct 2005 13:38 GMT

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

> 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
[quoted text clipped - 3 lines]
> a single reference field? And what is a reference field for if it can only
> refer to its own duplicate?

Reply to this Message

Franck Dauché - 12 Oct 2005 15:07 GMT

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é

Reply to this Message