Drop-down menu schema question

[Rich S]

Howdy, howdy:

I have multiple T.O.s in my solution and in a few of them they have a text field named "City." Rather than each T.O. having its own City value list I thought I'd have them all access a single field ("City") in a T.O. named Preferences; it would be accessed via the "Use values from field: Preferences::City, show all values" drop-down menu set-up.

My question is: how to enable all the T.O.s to "see" the City field in the Preferences table? Do I need to link every T.O. to Preferences using the typical pk_city_ID/fk_city_ID relationship, or...?

TIA for your help!

Rich

[Søren Dyhr]

No building a value list doesn't have to rely on relational ties, and yes a single pilcrow delimited field is suffice.

--sd