General information
Category:
Forms & Form designer
John, I think this may be the answer I am looking for. It seems this would be faily common stuff when using surrogate keys. You don't want to display the keys.
Thanks for the help, I'll try this later.
>A really goofy way to do this is to bind on the descriptive field (resolves what's displayed) and use a view and do a REPLACE on the key on LostFocus. This is what I've been forced to do in the past.
>
>>>>>I think that sparse property should do this. Also, there is really another way to do this job:
>>>>
>>>>Sparse shows the boundcolumn, which is the surrogate key. I don't want to display the surrogate key.
>>>>
>>>>I want to change the key value, but display the discriptive value.
>>>
>>>Currently, I use the next column to display the discriptive field. It's ControlSouce is bound to the surrogate key in the lookup view. I use the second view and set a relation to it to avoid having to requery every time the user changes the supervisor. I only requery after the user choses to do an update. The user can change many records before update.
>>
>>Sorry, the only thing I understand is that you set some relations. Whatever these relations are, you should not use them within a grid: they will give you tons of funny-looking problems.
Previous
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only