>>>>>It's lookup by foreign key. You may call any method/procedure from controlsource expression to accomplish it.
>>>>
>>>>Ok, that's what I suspected. Then I don't like it.
>>>>
>>>Why? It's normal way.
>>
>>If you're doing lookup, you're connecting to the table every time. I'd like to be able to disconnect.
>
>It has nothing to do with connection. You do Seek in a table. If someone changes 'Software' table in the meantime then user will be informed about description change right on spot. What's wrong with that?
>Or you mean that you use SQL-Server data?
I'm using VFP native data. I can probably simply go with set relations. My concern is that I would not be able to sort on the column if I go this route.
If it's not broken, fix it until it is.
My Blog