Extracting List of Companies from a Contacts solution

[fchieli2]

I have a single table containing First Name, Last Name and Company Name. Let's say I have 100 contacts and all those contacts belong to a pool of 15 companies. How can I display one instance of each company in a single text field ? It's easy in a report, with subsummaries...

In other words I'd like to have a single text field displaying the 15 companies existing in the system as unique entries:

company a

company b

company c

etc...

not as

company a

company a

company a

company b

company b

etc...

Thanks in advance for you help!

[Lee Smith]

I'm not sure I'm am following you completely.

However, if these companies are all in separate records, in a field called say (company), than a value list based on the field (company) will only show one value for each unique name.

If I missed the point, then try saying it a different way.

Lee

[fchieli2]

I got that far, but let's say you need o create one record per company in a different table, how would you create a relationship that will list all the companies, but only once?

Thanks again for your patience!

[Ocean West]

You can keep contacts and company in the same table and do a self relation to find only companies you could search on the foreign key field to be blank or null. This would find one record per company.

Records that contain a foreign key would be a contact record. This way you don't have to "tag" each record with a type label.

But you would have to create one record for each company.

you could sort things in an order and then use conditional formatting to only highlight company records.