>Hello Allen.
>
>>> boundcolumn 1
>columncount 4
>Rowsource customer.name,maillist,addr1,city
>Rowsourcetype 6 - Fields <<
>
>Does it have a ControlSource or is the ControlSource empty?
>
>>> The file is indexed on name+zip (zip is not included in the list) <<
>
>Does the customer table also have a Primary Key? If so, this would be the easy answer. You'd set up your combo like this:
>
>.RowSource = "customer.name, maillist, addr, city, custPK"
>.BoundColumn = 5
>.BoundTo = .T.
>.ColumnCount = 5
>.ColumnWidths = "200, 100, 100, 100, 0" && or something like this...whatever looks good visually
>.ColumnLines = .F.
>
>>> Also I assume I need to do a requery after adding a new record. <<
>
>That is correct. Requery() is how the combo updates its internal list from the underlying data source.
You can just set your column count to 4 and not have to deal with a width for it at all. You'll still have 5 columns (as specified in the RowSource) and can be BoundColumn set to 5, you just never see it.