Setting up Notes
I previously set up a group of related Notes tables, and it seemed to work fine, but there were a few nuances that I didn't particularly like. So I am rebuilding it from the ground up and had a few qu...
Forum Discussion
Andrew -
You're correct in thinking to make the Type and Subject fields Text. Since these are their own tables, the use of a Text-Multiple Choice is redundant and will only cause more issues later. The structure of this setup doesn't need to be super complex, but you are right in thinking you will need a Many to Many table for the Types/Subjects. I would suggest a structure like this:
------------------------------
Blake Harrison - DataBlender.io
Quick Base Solution Provider
------------------------------
You're correct in thinking to make the Type and Subject fields Text. Since these are their own tables, the use of a Text-Multiple Choice is redundant and will only cause more issues later. The structure of this setup doesn't need to be super complex, but you are right in thinking you will need a Many to Many table for the Types/Subjects. I would suggest a structure like this:
------------------------------
Blake Harrison - DataBlender.io
Quick Base Solution Provider
------------------------------
Blake,
I really appreciate the simpleness with which you described everything and the images you shared for clarification. Thank you!
I believe I have my table relationships set up correctly, but just want to be sure.
Here is what I have for my Note Type Subjects (NTS):
Here is what I have for my notes table:
I already had all my Note Types and Note Subjects input into their corresponding tables, as text, before creating the M:M NTS table.
Would I be correct in understanding that I need to edit each Note Type to associate it with the various Note Subjects, to have the Note Type to Subject relation appear in the NTS table, and then in the Notes form drop downs?
Still working on getting the correct field adjusted for the conditional options.
Thanks for your insight!
------------------------------
Andrew
------------------------------
I really appreciate the simpleness with which you described everything and the images you shared for clarification. Thank you!
I believe I have my table relationships set up correctly, but just want to be sure.
Here is what I have for my Note Type Subjects (NTS):
Here is what I have for my notes table:
I already had all my Note Types and Note Subjects input into their corresponding tables, as text, before creating the M:M NTS table.
Would I be correct in understanding that I need to edit each Note Type to associate it with the various Note Subjects, to have the Note Type to Subject relation appear in the NTS table, and then in the Notes form drop downs?
Still working on getting the correct field adjusted for the conditional options.
Thanks for your insight!
------------------------------
Andrew
------------------------------