> I have made the relationship and made it where each record can be created via the relationship in both directions. yet I am not getting any records in the completerecords table at all.
It won't happen automatically just because you've set up a relationship. You need to create a script that will compare the current data in the Client record with the last saved record in the Data_Complete table, and if the data has been modified, then a new related record is created in the Data_Complete table and the modified data is then copied into it.
This can be implemented with a script trigger, so that when the user exits the Client layout, the script automatically checks to see if the data has been modified, and if so, it then creates a new record in the Data_Complete table and copies the modified data across (using variables). No interaction from the user is needed, it just happens automatically in the background whenever the user exits the layout.
Here's a sample database that illustrates the idea:
The "Save record..." script is attached to the Client layout as a script trigger - OnLayoutExit.
The comparison between the current Client record and the last saved record in the Data_Complete table is done with variables and the List function.
Hope this helps!