>I found a stupid workaround for the autofill, fox's foundation class is strange at best.
>
>I do not understand Hilmar's code for scatter and gather what is name (do I make this up) and what is lorecord.
>
>When the customer uses this program they will select X record to transfer to the next stage or table ie from Bulb/Veg to Plant/Flower etc... to sales finally.
>
>I hope I have stated properly what I am trying to do and understand.
>
>Thanks for all the quick responses.
>
>Sincerely,
>
>Fred W.

How exactly the customer selects record(s) to transfer? As I said earlier, if they use some criteria to select records, you would use it in INSERT-SQL and DELETE-SQL commands.

If they select only one record, then you can do

scatter name loRecord memo
insert from loRecord into myNewTable &&(verify this syntax, please)
delete from myOldTable where ID = loRecord.ID

I wrote this from the top of my head so you may want to check syntax for these commands in Help first.