sorry new user
I want to create a conversation database
one table person
one table topics
I am struggling with allow linking to multiple records or not.
If don’t multi-link records, I don’t get the “link to a record in topics table” option…
I would have to leave the person table and switch to topics table and enter the new note and select the appropriate person to link the note.
then I I go back to the person table, the new not is listed with all prior notes…
if I use the multi-link reconds options, I have to click on “link to a record in topics table” take me to the notes table and I can create a new note… very smooth…BUT
the problem is not only can I create a new note, but I can also link to any note in that table that hasn’t been link to a specific person’s name before. there are a lot of records in this table… I would like to have just the ability to create a new note, not pick a prior note that is link to a different person.
Does this make sense?