Forum Discussion

LesterBird's avatar
LesterBird
Qrew Member
5 years ago

Matching multi-select field in one table to a field in another table

Hi, I have two tables - projects and states. Each project occurs in at least one state, but sometimes in more than one state. So I created a multi-select field called Project States in the project ...
Relationships
Tables and fields
JustinTorrence's avatar
JustinTorrence
Qrew Cadet
5 years ago

@Lester Bird

By a long shot, the most stable solution is going to be through the use of a many-to-many relationship. These can be challenging to set up and don't offer the most in terms of elegant user experience, but they will help you produce the data you are looking for. 

Cheers



------------------------------
Justin Torrence
Quickbase Expert, Jaybird Technologies
jtorrence@jaybirdtechnologies.com
https://www.jaybirdtechnologies.com/#community-post
------------------------------