Dan: I too wish I could use DBGrids more often because they look so
professional. But lookups are what keeps me going to scrolling region. What
you can
do is trap the PK of the row into a form expression and on a "row enter" eep
display the variable info off to the side. But you would only see data for 1
row at a time.
> I want to place a column as a variable lookup from another table but have
> not figured out how yet.
>
> The user needs to be able to edit/add/delete rows.
>
> A sample of my db grid table
>
> PartNumber Description(lookup) Quantity
> A286 Computer 286 1
> A386 Computer 386 3
>
>
> Has anybody been able to do this??
>
> I can do it with a scrolling region but the db grid is more functional and
> cleaner.
>
> TIA
>
> Dan Goldberg