Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Theory Question
Message
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
Miscellaneous
Thread ID:
00571894
Message ID:
00571904
Views:
23
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
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform