>How does your text box handle changes to the 'visual code'? I take it, the control isn't bound but has some extra property to tell it waht field to update and with what value? - this also has to work in grids????
>

I haven't actually created the class yet... so, that won't help you this morning... I would say, for your demo, just bind the textbox to the Visual Key for now, and mock up some kind of PickList.

Doug Hennig wrote a PickList class that is very flexible... using this in combination with a custom textbox class is what I was going to put togther.

But, yes, as far as the text box goes, I was actually thinking of having two text boxes in a containter. One would be invisible but would be bound to the Foriegn Key... The visible text box would hold the Business Key... I was also thinking of adding a label to the class that would display the description of the key.

From there, the class would contain the information necessary to query the data for three reasons...

1. To get the 'Visual Values' based on the FK
2. To verify any Business Key that was entered
3. To create a picklist of valid values (this would be based on dougs class)

>Any help would be very much appreciated, especially as we haven't got time to look into at the moment!


Anyway.. that was the plan.. perhaps when I get it working it would be a good class to publish. In my case, the tough part is that it would have to work for remote and local views.

Well, good luck to ya!

BOb