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

 

[PWise]

Select ownerid,nz(company ,"") & nz(", " + owner,"") as ownercompney
from owners

 

[PWise]

put this as the row source of the combo box

change the names of the fields and table tou your field table name