I have data sitting in a Access database .., Just for development where I plan to upscale to SQL server.

My problem is I have two tables:Table_A, Table_B

I have two views View1 = Table_A
and View2 = Join of A+B

update View1 set flag = m.chrtime where lockid = "JO" and actiontime < m.thistime
tableupdate(1)

*set step on
select View2
requery()

Now I have async processing flagged in the connection and its a local data session to the form, I used fox to create the views I didnt code them myself.

If I uncomment the set step on it works ... assume the second view is firing before the fitst saves back and the set step on allows it to happen

Should I build the views myself ?

- James