Value List without individual records for each value?

[hellohelp]

I'm trying to create a value list for use in a popup. Each record is a company, and each company has up to eight locations, each location name defined by a separate field in the record. Now, I see from examples in this forum that I can create a new table, linked by a primary key (say, Company ID), and then create a new record with the primary key and the field value for each location in order to make a popup list. That's fine. But is it possible to keep the field values directly within the company's record, so that I don't have to make a separate table for the locations? It seems like I cannot because popup lists only want to grab from one field, whereas I need it to grab from eight. Is there any way around this?

Thanks!

Tom

[Razumovsky]

Hi Tom,

You could do this by basing your value list on a stored text calc that is essentially:

Location1&¶&

Location2&¶&

Location3&¶&...

but it is a pretty bad idea and will likely cause you headaches down the road (as well as today). Putting the locations in a different table is quite simple, and the correct approach. Even putting them in a repeating field would be better than what you have at the moment I think.

Welcome,

-Raz