Help with a linking table

[YuvalH]

Hi, I'm in a process of creating a file tagging system. I'm trying to create a table that will display for every file what tags are assigned to it. I tried several ways with relationships and it doesn't seem to work.
EXP:

for file num 1 I have tags 1,4,5.

I made "Tags" multiselect with the wizard.

Thx for help

 

[MajP]

You need a junction Table for a many to many. A tag can be related to many files. A file can have many tags.

TblTags
  FileID_FK
  TagID_FK

MS Access - Many-To-Many Relationship

MS Access - Many-To-Many Relationship - In this chapter, let us understand Many-to-Many Relationship. To represent a many-tomany relationship, you must create a third table, often called a junction table, that breaks down the many-to-many relationship into two one-to-many relationships. To do...

www.tutorialspoint.com

 

[MajP]

If you use a multi value field (these are bullcrap) then I do not know if you can actually build a relationship. A MVF creates the junction table as a hidden system table.

 

[Pat Hartman]

As MajP said, MVF's are nothing but trouble. Multi-select list boxes are NOT bound so unless you want to write code to manage the junction table that way, the best physical representation will be a subform. You can do that without any code at all. The visual is not as great as the one with the MVF but you can come close. The difference is that the subform will show only selected items whereas the MVF and multi-select list box show ALL items with checkmarks for those selected.