Sorting, Searching, or Both?--a question to keep in mind.
The basic set up that I would use would work like this:
Notes::__pkNoteID = Note_Tag::_fkNoteID
Tags::__pkTagID = Note_Tag::_fkTagID
You can place a portal to Note_Tag on the Notes layout to list and select Tags records for each given Notes record. Fields from Tags can be included in the Portal to show additional info about each selected Tags record and the _fkTagID field can be set up with a value list for selecting Tags records by their ID field.
Notes would be a table with one record per note. (You can also set up another related table to group notes by "project".)
Tags would be a table with one record for each Tag.
Tag_Note would link one note to one tag so that you can link one note to many tags and also link one tag to many notes.
hey sorry, Phil. Thought I answered this ages ago. This was super helpful. Thanks so much!