Forum Discussion
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...
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.
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
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
- That was an incredibly helpful article, thank you! I do not intend to query the attachment field, and I am not particularly concerned about File Bloat, though this would be an issue for larger databases. If I do have to query an MVF field, I will revise what was discussed in the article.
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.