OK Craig, I'm finally getting back to this problem and I want to explore your suggestion first. In my grid I set the rowsource to

SELECT ; 
test_financing.amount,test_financing.source,test_financing.phase ;
from tip inner join test_financing on tip.tip_id = test_financing.tip_id

this produces a browse window when the grid inits. Are we supposed to SELECT into a cursor when the result is going into a grid? Upon closing the browse I get a syntax error with an OK button but no indication where the error is. Can you help further?


>Views are not that difficult. Think of it as a read/write cursor to the data. When you issue a TABLEUPDATE(), changed information is written to the database.
>
>>I do.
>>
>>>Only if you want to update the data.
>>>
>>>>OUCH! That means I have to learn about views, right?
>>>>