<< 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. >> Here's a possible solution to your problem, although not without it's own issues (chiefly, performance):
1. Create a stored procedure called TLOOKUP with three TEXT parameters -- expression to look up, table to look into, and WHERE clause, and returning type TEXT or NOTE. The code in the procedure should SELECT <<expression>> INTO vReturnVar FROM <<table>> WHERE <<where clause>> and RETURN .vReturnVar. 2. Now, create a single table view on your original table, with additional expression-type columns that use the TLOOKUP stored procedure to look up the value you want in the other table. The new view will now be fully editable, since it features only one
