General information
Category:
Forms & Form designer
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.
Previous
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only