Apr 24 2022 07:35 PM
Hi Everyone,
I think I have screwed up. As I have previously talked about, I have a many to many relationship. I was originally using MVF, until a few members on here told me to use a junction table. Here is the problem. I didn't actually remove the MVF, and that is what the database has been running on. I have started doing queries, after I made all my forms. Do I, A. Continue with MVF and try to figure out how to do queries that way (Will need a lot of help from this community and others) or B. How do I remove the MVF, whilst still using the Junction Table. If B is the better option, how do I use it in a form? I will attach my database. I really need some help!
Apr 25 2022 06:50 AM
Apr 25 2022 09:14 PM
Apr 26 2022 05:44 AM
Apr 26 2022 03:30 PM
Apr 27 2022 06:48 AM - edited Apr 27 2022 01:16 PM
Your choice entirely.
However, if you don't intend to get rid of the MVFs or attachment fields, I do wonder what the point of this thread actually is.