Forum Discussion

Jqws13_'s avatar
Jqws13_
Copper Contributor
Apr 25, 2022

Big Problem with MVF and Junction Table

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!

  • You have both MVFs and attachment fields (another type of MVF)
    Suggest you get rid of BOTH before you go any further - if you don't you will regret it.

    As you don't have much data (yet), its probably easiest to just make a backup copy of the existing tables for use later, modify the structure of the main tables removing MVFs and attachments then transfer the relevant data. Hope that makes sense
    • Jqws13_'s avatar
      Jqws13_
      Copper Contributor
      Hi IslaDogs, This is just a project, it is not going to be used to input or store data, if that's why you are warning against MVF Fields. The size of the database is not really going to change.
      • isladogs's avatar
        isladogs
        MVP
        You have already entered data, so I don't understand your comment.
        I am strongly recommending you abandon attachment fields due to file bloat but even more important is the fact that both MVFs and attachment fields are so difficult to query.
        In case you haven't seen it already, please read my article https://www.isladogs.co.uk/multivalued-fields/index.html

Resources