Thanks @NigelG, that is what I figured wile thinking about it last night… ;o)
But the implementation still escapes me. It seems impractical to have each of the cases the attorney have separated by comma. How would I do that? each case record is a line in the csv file. An attorney could have hundreds of cases in years of work.
I have a table of attorneys – geez, everyone in the forum probably know about this now! ;o)
in it I have a field “Cases” of Type “Case” which points to a list of elements in the Case table.
In other words: each attorney can have many cases.
Looking into the reference it is confusing. It says that as an example, you have a list of apartments (just like I have a list of cases) and you have a field which is the owner (my AttorneyID in the cases table)
So it seems to say that I should pick the AttorneyID as my composite field. But I am importing the cases information and trying to match the AttorneyID in the case table? That makes no sense. It should be trying to match the AttorneyId from the imported case.csv with the AttorneyID in the Attorney table.
If I do the other way around: First import all the cases, then import the Attorney information and match the AttorneyID with the Cases, the reference says it will give an error:
“If two entries in your Bubble app database match the same value, an error will be returned.”
Since the AttorneyID will appear for multiple cases already in the database, an error will be returned.
It does seem that it should be, import the Attorney data first, then import the cases. But how do I tell the Attorney database that this case I am importing is part of his list?