>I delivered the software Friday and of course there were some problems, the only issue I have not solved yet is they have about a hundred or so more inventory locations within each area or room than I previously had discussed with them.
>
>All that to say my "lookup table or location table was 1 field with x amount of areas lookup through combo box (Your idea thanks!!!) the problem is when I go to add all of these other locations to the individual rooms the lookup box is huge I am trying to see if you know of a different way other than designing a lot of individual lookup tables???
>
>Your record transfer routine works also and I have 1 more question about that, when I am transferring a record with
>
>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.
>
>Will this effect records since 1 of the fields in each record that is being "transferred" is auto incr integer it is a lot field which exists in all tables???
>
>Wow that was a lot of words for 2 questions!!!
>
>Thanks again for all the input.
>
>Sincerely,
>
>Fred W.

Hi Fred,

I'm sorry, can not check right now, but AFAIK scatter command has EXCEPT clause. So, you would have to exclude the ID field. If the field is excluded, it would be calculated automatically on the insert.