Hi Kevin,
Set your combobox properties to
RowSourceType = 6
RowSource = "Addr_Types.Caption,RecordID"
BoundColumn = 2
BoundTo = .T.
HTH
Michael Henstock
AWS
>I have a client table, related into an address table. The address table is
>related into a lookup table called Addr_Types, which contains address
>types; Billing, Shipping, ect...
>
>I want to populate a combo with the lookup types. The structure
>of Addr_Types is:
>
>
>RecordId Caption
>----------------------------
>1 Mailing
>2 Billing
>3 Shipping
>>
>How do I then populate the combo so that the user sees the caption
>in the combo, but the record Id is stored to the Address table?
>
>Thanks for your help
A fish this fine deserves to be a fish nugget styled chunklet.
- Fry