The copy previous record, short cut (Ctrl Shift R) doesnot seem to work all the time. My table consists of:
(1)Date
(2)Member ID
(3)Member Name
(4)Part No
(5)Part Name
(6)Qty On Hand
(7)Qty Ordered
(8)Cost
(9)Total Cost
(10) Paid For
(11) Received
I add (and save)a record. Then I Copy the previous record
using Ctrl Shift R, it works perfectly. I can make whatever changes I want and then save the record.
But, when I add field rules, strange think happen.
When I hit Ctrl Shift R, the record is added, but a new blank screen appears with only the last two fields filled in (10 & 11 Above).
I know the record has been copied. At the top of bar memu
there is a white space that shows the record #. Lets say it is record 6. When I hit Ctrl Shift R, the record # gos to 7. Now if I right click the Previous (Page up) icon, it shows record 6. When I right click the Next (Page down) icon, record 7 (the one I just copid) appears fully filled in, of which I can change something and save or just save. What is going on. Why when I do a Copy Previous record, I get a new blank record to start inputing.
Fields 2 & 3 are field rules for table lookups.
fields 4, 5, 7, & 8 are field rules for another table lookup.
Field 9 is a cal using fields field 6 * field 8.
Fields 10 & 11 Are "Y" or "N" (Yes or No)
I have been using many many ver's of Alpha 4 & 5 and have never seen "Copy Previus Record" act like this. I have gone back and deleted all field rules, and the Copy Previous works perfectly. But when I add fields rules, the above happens.
One other think. This is a small record, only 11 fields with 10 fields having some kind of field rule. I have other table with many fields (50) and only somewhat few
field rules (20). Maybe the fact that I have a very large percentage of the fields set for field rules is causing this to happen. I just can not do what I want to do with the "Copy Previous Record" working as it does.
(1)Date
(2)Member ID
(3)Member Name
(4)Part No
(5)Part Name
(6)Qty On Hand
(7)Qty Ordered
(8)Cost
(9)Total Cost
(10) Paid For
(11) Received
I add (and save)a record. Then I Copy the previous record
using Ctrl Shift R, it works perfectly. I can make whatever changes I want and then save the record.
But, when I add field rules, strange think happen.
When I hit Ctrl Shift R, the record is added, but a new blank screen appears with only the last two fields filled in (10 & 11 Above).
I know the record has been copied. At the top of bar memu
there is a white space that shows the record #. Lets say it is record 6. When I hit Ctrl Shift R, the record # gos to 7. Now if I right click the Previous (Page up) icon, it shows record 6. When I right click the Next (Page down) icon, record 7 (the one I just copid) appears fully filled in, of which I can change something and save or just save. What is going on. Why when I do a Copy Previous record, I get a new blank record to start inputing.
Fields 2 & 3 are field rules for table lookups.
fields 4, 5, 7, & 8 are field rules for another table lookup.
Field 9 is a cal using fields field 6 * field 8.
Fields 10 & 11 Are "Y" or "N" (Yes or No)
I have been using many many ver's of Alpha 4 & 5 and have never seen "Copy Previus Record" act like this. I have gone back and deleted all field rules, and the Copy Previous works perfectly. But when I add fields rules, the above happens.
One other think. This is a small record, only 11 fields with 10 fields having some kind of field rule. I have other table with many fields (50) and only somewhat few
field rules (20). Maybe the fact that I have a very large percentage of the fields set for field rules is causing this to happen. I just can not do what I want to do with the "Copy Previous Record" working as it does.
Comment