I think that your relationships are:
Artists----<Titles-----<Impressions (---< means "one to many" )
Apparently, you have these match fields:
Artists::Firstname = Titles::FirstName AND
Artists::Lastname = Titles::LastName
Titles::FirstName = Impressions::FirstName AND
Titles::Lastname = Impressions::Lastname
When you should have:
Artists::Artist_ID = Titles::Artist_ID
Titles::Title_ID = Impressions::Title_ID
The Artist_ID field in the Impressions-table records are, as yet, empty.
If I have correctly recreated your relationships, this field should be removed from the Impressions table as it is not needed.
If your current names in the first and last name fields are correctly matching by name, you can set up the needed links by using Replace Field Contents to copy over all the Artist_ID and Titles_ID values.
Go to a layout based on Titles.
Show All Records
Click or tab to put the cursor in the Titles::Artist_ID field
Select Replace Field Contents from the Records menu and select the calculation option.
Select Artists::Artists_ID as the sole term in the calculation.
Do the replace Field Contents operation.
Now update your relationship between Artist and ID's to match by Artist_ID instead of by the name fields.
My assumption is that your statement: "Likewise, the Titles and Impressions are related one-to-many." means that you have possibly many records in Impressions linked to one record in Titles. If that is correct, you would not link records in Impressions to records in Artist by Artist_ID, nor would you link Impressions to TItles by Artist_ID unless you intend a signicant change in your relationship where your impressions link to an artist instead of a title. This would produce the same set of impressions for every title linked to the same Artist record.
Thanks. That makes sense. Your assumptions are mostly correct.
"If your current names in the first and last name fields are correctly matching by name, you can set up the needed links by using Replace Field Contents to copy over all the Artist_ID and Titles_ID values."
Therein lies the rub. The names are not all correctly matching between Artists, Titles and Impressions. I am working with imported tables where some data is missing or incorrect (mis-spelled, double-entries, etc.). In a few cases, the Artist names are "unknown" or "?" and so I'm getting doublings of Impression records in some of my layouts such as Drawer-Contents and/or Packet-Contents (where the prints are archived).
I'll try the Replace Field Contents procedure as you outlined. I see I was doing it wrong (not using a calculation).
Your point about not needing the Impression::Artist_ID is well taken but for my need to rehab the old tables. I guess I should work on making the screwed-up first and last names to be unique somehow like, assigning numbers to "unknown" and/or "?". That might be simpler.
It sounds like you'll need to do a lot of data review and "fixing" as you go. For example, you can do a find for an artist name using the first few letters of their name(s) and maybe some wild cards or you can use multiple find requests or extend found set. Then review your list and omit any records that aren't for the same artist. Once you have a found set of records all for one artist, you can use replace field contents on one record that does correctly match by name to pull over the ID number for all records in your found set by NOT using the calculation option but just the "current value" setting.