Trouble With Related Tables
I posted an issue related to this and I thought I found a fix. But now that we are into heavy use, problems are starting to arise. We have 2 tables (CUSTOMERS, and PRINT TABLE). The PRINT TABLE table is created automatically through calculation. The tables are related through a RECORD ID. The CUSTOMERS table RECORD ID is indexed and autocompleted using GET(RECORDNUMBER). The PRINT TABLE table RECORD ID is unstored and autocompleted using GET(RECORDNUMBER). And there is a script operating from a field trigger that adds records to the PRINT TABLE table for the fields to filled in:
Set Variable [ $RecordNumber; Value:Get ( TotalRecordCount ) ]
Go to Layout [ “Print Table” (Print Table) ] Go to Record/Request/Page [ Last ]
If [ Get ( TotalRecordCount ) > $RecordNumber ]
Delete Record/Request [ No dialog ]
Else If [ Get ( TotalRecordCount ) < $RecordNumber ]
Go to Layout [ original layout ]
The problem we have is when a record is deleted the tables no longer align or matchup. I have thought about giving up and merging the tables, but the CUSTOMER table is large enough with essential, non-duplicate information. The PRINT TABLE table is duplicate information from the CUSTOMER table setup in different ways to help with all the various printing layouts. It really makes sense to keep them separate, but now I am at my wits end trying to get it all to work.
Any help or advice would be greatly appreciated.