multi field value causing issues - Using Shelly Cashman Series

[carterkate]

Hi!

I'm currently in a school program and learning how to use Access. I'm using the textbook by Shelly Cashman, "Microsoft Office 365 Access 2019". I'm on module 3 incase anyone is familiar.


I have a table with information about Appointments. I made a Multivalued Field on the Appointments Table.
My next step pertaining to the multivalued field is to fill it in and make two queries about it. They both work fine.

This is where my issue comes in. Next, I'm to open an existing query "Appointments and Treatments" to test the query and rejoin the lines. When I try and open it I'm met with the line "The multi-valued field Appointments.[TreatmentNumber] is not valid in the specified JOIN clause.

How can I fix this? I have restarted this module numerous times and I can't seem to figure out where I went wrong or why this is happening. I'm incredibly frustrated as this needs to be corrected since I'm getting marked. My teacher is wonderful but I'm not finding any value in the emails.

I appreciate your help!

[Welshgasman]

Most developers avoid MVF fields, and do it the old fashioned way with a 1 to many relationship. MVFs are actually this as well, but the relationships are hidden.
If I was you, I would use the old fashioned 1 to many relationship. Then your join should be simple.

[carterkate]

That's what I've been reading online too. The only hiccup is I'm following these instructions for an online school course so I can't variate from the steps I'm given.

[Welshgasman]

So show your sql and which field is the MVF.?
I would not thought you would be joining on that field anyway, but the FK for that record?

Attach the DB even, though my Access is too old to view it, others should be able to.

[orange]

I suggest that you post "the steps I'm given". Readers will advise based on the specifics/requirements.

Richard Rost has a youtube video on MultiValued Fields.