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.