AnsweredAssumed Answered

Trouble With Related Tables

Question asked by Fred_3 on May 28, 2015
Latest reply on May 29, 2015 by Fred_3


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 ]

         New Record/Request

End If

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.

Thanks.  Fred