We are enhancing a manufacturing data set to allow one or more operations for each part, and one or more sub operations for each part + operation combination. As we are updating over 1,000 parts with one or more operations, the user needs to assign the sub operations from scratch.
I have created a form with the linking table which contains four columns: an abitrary integer PK, autonumbered, that I really don't care about, the part (text 12), the operation (integer) and the sub-operation (integer). The user goes into the form by specifying a wild card for the part number. He could specify "23" and every part starting with the characters "23" will appear. The table will be ordered by the part and the operation. The table has been pre-loaded with all combinations of part and operation, with a single instance of the combination. The sub operation is null. My problem is that when the user adds a second sub operation, the new row is at the very bottom of the region. This is very, very inconvenient for the user. I have tried: PROPERTY TABLE <tablename> "REFRESH" NEXTTAB PREVTAB RETURN on an eep on saving the row, but this does not return the user to the row with the null sub operation that he just added, which is what we want. We want to be able to [+] for a new row, and have that row display immediately below the row the user was on when he clicked the [+]. Any ideas? Albert Berry Management Consultant RR2 - 1252 Ponderosa Drive Sparwood BC, V0B 2G2 Canada (250) 425-5806 (250) 425-7259 (708) 575-3952 (fax) [EMAIL PROTECTED]
