I have read your problem and would like to help you find a solution however there is a lot of confusion with the information provided.
What exactly is this database supposed to do? (whats the print table for is basically what i'm asking) I ask because I just don't understand why have 2 tables with the same information, you can just create different print layouts for your different print needs, if needed you could create another table occurance of your customer table allowing you to create relationships to display the data differently.
If you can explain a bit more about your solution you might find others able to help you out as well.
Thank you Yoshi.
The PRINT TABLE is more than just duplicate information of the CUSTOMERS table. It is all autocompleted fields through calculation, but the calculations are all very detailed, i.e. a simple date field in the CUSTOMERS table yields 6 different date fields in the PRINT TABLE with years added, IF statements, etc. Merging the 2 tables makes the primary(?) table (CUSTOMERS) really big and messy.
You're correct. A more simplistic way to resolve this is with different print layouts, but I have not been able to add IF statements to print layouts. If that is possible, than this original problem goes away.
The CUSTOMERS table RECORD ID is indexed and autocompleted using GET(RECORDNUMBER).
That won't work. You need an auto-entered serial number.
All Get ( RecordNumber ) returns is the postion of the record in the current found set. IF this is a stored calculation field or auto-enter field, it will be the position of the record at the time that it is first corrected. Simply sorting your records, performing a find, omitting records will all change the value returned by Get ( RecordNumber ).
Thank you Phil. The auto-entered serial number was what I needed.