Back to VFP - memory failure 1

[Bryan - Gendev]

I'm getting back to VFP for a friend who wants a membership database.

I have imported data from two xls files.

I have the basics in the app working well. But I want an improvement.

As an example that will be one of a number....

On the form for each record in the members table I have the field content shown in a text box.

Improvement wanted - >In the past I used to use a combo for say, the membertype, where I have the type recorded as an integer in the members table and want to show the actual type from a memberstype table with a drop down to allow the user to select the type.

When I use the vfp builder for the combo I still see the number from the members table on the form.

I just can't recall where I am going wrong. What values do I put where in the combo please?

GenDev

 

[Dan Freeman]

Since you're binding a dropdown to an integer it's REALLY IMPORTANT to know which version of VFP you're working with.

Assuming this is VFP9, the builder lets you specify the order of the fields displayed in the combo. Make the text field first and the integer second, set the width of the integer field column to 0 (and you'll probably want to turn off column lines, which isn't available in the builder), and bind the integer colulmn of the dropdown to the integer field of the underlying table.

The builders can be a little limited but you can get there on this one.

Then go read about the BoundTo property in the help file.