Skip to main content (Press Enter).
Skip auxiliary navigation (Press Enter).
Quick Base University
Skip main navigation (Press Enter).
on this day
between these dates
Back to discussions
sort by most recent
sort by thread
I'm used to other types of database systems (Filemaker, MySQL, etc) which allow secondary non-unique...
Quick Base does not support a secondary Key and my understanding is that this is a legacy issue tha...
Posted 03-01-2019 15:51
I'm used to other types of database systems (Filemaker, MySQL, etc) which allow secondary non-unique keys and I'm wondering why this isn't possible in Quick Base. Is it simply a limitation or am I missing something?
Here's an example of where I ran into trouble. I have a 'teams' table as parent which relates to a 'team members' table. 'Team member' has a user field. I would like that user field to be a key field for other tables further down the tree but I also want users to belong to more than one team. Normally this would be easy with secondary keys but in Quick Base it gets very cumbersome.
RE: Secondary Keys
Posted 03-01-2019 16:04
Quick Base does not support a secondary Key and my understanding is that this is a legacy issue that is not easily enhanced.
But that being said, there is generally a solution working with the wide range of flexibility that we do have. So for example, in your case a Many to many relationship where One Team has many Team Members but also One Team Member may be a member of Many Teams.
So my motto is "Don't let the things you can't do stop you from doing the things that you can".
New Best Answer
This thread already has a best answer. Would you like to mark this message as the new best answer?
Skip Navigation Links
Terms and Conditions
Powered by Higher Logic