Thank you all, for your helpful responses.
Initially, before posting, I had considered Rebecca_Elam’s idea. However, I didn’t know how to deal with an unknown number of names (and I am just a private user creating my own personal sheet music library with the free version [hence no blocks]).
There are composers with more than three given names. The longest of which I am currently aware has 30 names. (Named after each member of his father’s orchestra.) Admittedly, that is absolutely off-the-charts, most unusual case. But, it illustrates the point that I didn’t want to have a built-in limit.
But, since I don’t have scripting (I’m thinking I need blocks for that, am I incorrect?), I decided to go with a maximum of two initials (I’m just leaving Bach’s son, and others with more than two given names “in the dust” and only including the first two initials) by having three fields: first name, middle names, and last name, and using the first initial of the first name and middle names fields.
I’ll use that until I find (from actual experience) that it is a showstopper!
Thank you again.
Now, on to figure out how to make a user interface (like a form) to permit entry by user of search parameters (that is values to use in a filter [i.e. WHERE clause]) for a dynamic query. However, the more I look at Airtable, the more I think it’s database capabilities (I read that as SQL) are fairly limited.
Anyway, that’s a topic for another thread, which I will likely post, later.
DG
