Query fields not populating (1 Viewer)

View attachment Art Exhibits.accdb

Hello,
I've attached a (censured) database I'm working on.
In query qryBrochure, none of the fields from table tblIDArtistInfo will populate. I can't figure out why???

Thank you, Nancy

You are not properly linking tables. Membership is a number field and it is defined as primary key in tbllDArtistInfo. You are saving this value into a text field in tbtReceiving. A number field cannot link to a text field. Therefore, in your query you link Artist and LastName fields. Since Artist does not actually hold the artist name, the link does not return data in query. Fix field data type and link appropriately in query. You will have to remove the link in query first, fix field, re-link correct fields.

Names make very poor unique identifiers.

because you are using lookup fields in tblReceiving.

using lookups in table design is a bad idea because they create confusion when try to do anything else - what you see is not what you have. Remove the lookups in the table so you can see what you actually have, then rename the field to what you actually have and then you can write a query that will work. There is an error in your lookup anyway