I have a form, with a child table that has 0 or 1 record. From a button, I insert a new record with the correct foriegn key from the parent. In the next line, I select the primary key back from the table.
For some reason, it does not return any results.
p-code as follows:

select roomstbl
scatter fields room_key, maint_key memvar
insert into maint_sched (room_key) values m.room_key
select maint_key from maint_sched where maint_sched.room_key = m.room_key into array temp && the record realy is there!!!
if _tally > 0 && habit when selecting into an array
m.maint_key = temp(1)
endif
etc..
The insert works, the record is there, but _tally always remains 0
I'm stumped, p[leas advice.