Display two fields in record for a combo box field?

[Fredofthreads]

I am trying to display both the company name and the company name in the record for the "owner" field of an assets database. I have some customers who are a company and contact person, but the problem is the residential customers are only a contact person and no company. The list displays both company and contact, but the record only shows the company, blank for residentials. Is there any way around putting the res. customers name as the company name as well, as that would take time and weaken my database integrity?

Thanks,
C

 

[SeeThru]

You could use a simple combine in the combobox list rowsource:

[ContactsName] & ", " & [CompanyName]

This assumes you are using a hidden primary field key as the actual selection in the combo box.

If you want to get a bit more interesting, you can use an if to display the company name if there is one:

iif(isnull([companyname]), [ContactName],[CompanyName])



SeeThru
Synergy Connections Ltd - Uk Telemarketing and Telesales Services and
Synergy Mobile Solutions - UK Mobile phones, land lines and call packages

 

[Fredofthreads]

SELECT [Contacts Extended].ID, [Contacts Extended].[Company], [Contacts Extended].[Contact Name] FROM [Contacts Extended] ORDER BY [Contacts Extended].[Contact Name]; Is what was there, when i try the simple combine, it just gives me the id, which was an autonumber for the primary key.

 

[Fredofthreads]

Every time i try your iif function it just deletes it? what do i put for row source type? arghh.. so frustrating.

 

[PWise]

Why are you cross posting

 

[Fredofthreads]

my bad, but lets not worry about that, what did you mean by your post on that other one?

 

[PWise]

I will reply in my other post