I need help creating a snapshot field in a unique parent-child relationship.

Question

In my app, there is a relationship between two tables, call them Table A and B. In table A, there is a column called batch date. For this field, we would like to create a new field based off of it called initial batch date in the same table. This would essentially be the first value that was inputted in the batch date field (that field has end users inputting a value often). From the research I have done, the best way to preserve original values is using a snapshot field. From what I understand all I have to do is add a lookup field to the child table, then create a new field for a snapshot that effectively references this lookup field. The problem is in this relationship, table A is the parent and table B is the child. How would I create a snapshot field for table A in this situation? So far I added the lookup field in table B, then I created the snapshot there, and then added it as a summary field in table A to reference the original snapshot. This did not seem to give the desired result. Any suggestions? Open to anything. Sorry if it is not super clear as I am only a few months experienced in QB. Thanks,

donlarson · Answer

Brian,This is a common problem.&nbsp; &nbsp;Here is a solution for you using a reverse relationship.&nbsp;Make table Batch Date. Allow users to create records there but not edit anything.Create a Summary field between the Lab Test and Batch Date field to give you the Minimum value of the Record ID# in the Batch Date table.&nbsp; &nbsp;By definition, that is the first one created.Create a new Parent Child relationship between the Batch Date and Lab Test with Batch Date as the Parent.&nbsp; Make sure you use the Min RID Batch as the reference field when you create the relation ship.&nbsp; Do not let it create a new field.Now in the new relationship make Date a look up field in the Lab Test table.&nbsp; &nbsp;Change the name to something like First Date/ Original Date what ever makes sense for your lab.&nbsp; &nbsp;You can now use that Date in all your forms and reports and it will not change.You can also learn more about that Date, such as who put it in, [Record Owner],&nbsp; the date and time it was set&nbsp; [Date Created] and so on.&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;

Forum Discussion

I need help creating a snapshot field in a unique parent-child relationship.

1 Reply

Related Content

Create child records from Parent List - User field

Totaling Child Records Live on Parent Form

Many parent records on a single child record

Add child record through parent form and redirect back to parent form in edit mode

Pipeline to add Parent record from child import