Problems populating a Child_ID field when all table fields are calculations
I have a table with a field Parent_Table_ID which auto populates when I create a new record
I have 3 related tables to the above.
On two of the tables I manually enter data into fields so the Child_Table_ID will populate with the Parents data just fine
The third tables fields are all calculations based on data from the first two tables. how can I get the table to populate Child_Table_ID with Parent.
Any help would be appreciated
You'll need to add a field to that table that is NOT a calculation field and use it as the match field to link it in relationships to the parent table.