>>Is this a bad methodology? Should I be using a different type of object to select the current record?
>
>I use a button that fires up a look up form with a grid of the parent table, then I return the primary key and throw that in to the forigen key. I think, maybe I changed it to return the Record Number and do the value later. I think I'll put to gether a class demostrating this (sincemost of it comes from my framework) and upload it here. Maybe if I find time :-)
That's what I usually use, too - when the user has the ability to add records, it gives me the opportunity to show them the list before they add something that might already BE there (and profides editing capabilities). In this case, however, the user cannot add or edit the feild - so I thought the combo would be a better UI for the purpose....
Kogo Michael Hogan
"Pinky, are you pondering what I'm pondering?"
I think so Brain, but "Snowball for Windows"?
Ideate Web Site