Lorne,

I saw that Barbara wrote you and I agree that it should be a reason. Meanwhile,
try alen(temp)>0 instead of _tally. I don't think it makes the difference, but may be it helps?


>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.