CassidyPhillips
7 years agoQrew Member
Automatically create a parent record when info saved in the child reference field
Hi, I currently have two tables in a parent-child relationship: effectively I've got 100 parcels in the child table and each parcel is kept in one of ten boxes, which are kept in the parent table. Rather than using the RecordID as the key field of the parent table I'm using a text field, so each box can be individually named.
Normally when I'm importing a set of child records into a relationship like this I'll first create boxes 1-10 in the parent table, then import the list into the child table, but is this first step necessary? Is there any way that Quick Base can read the contents of the reference field in a child record and, if that information doesn't match an existing parent record, automatically create a corresponding record in the parent table?
Normally when I'm importing a set of child records into a relationship like this I'll first create boxes 1-10 in the parent table, then import the list into the child table, but is this first step necessary? Is there any way that Quick Base can read the contents of the reference field in a child record and, if that information doesn't match an existing parent record, automatically create a corresponding record in the parent table?