Composite Index for Quick Base Table
Hello, I have a table named Certifications which has 2 parent tables: Publishers and Formats. I need to ensure there are no duplicate combinations between publishers and formats. So what I tried wa...
Forum Discussion
Why, yes, now that you mention it! It looks like Related Ad Format was a lookup field. We had changed the key field for that table.
I changed my formula to reference the key field instead, and now it works! Thank you!
------------------------------
Rachel Rachel
------------------------------
I changed my formula to reference the key field instead, and now it works! Thank you!
------------------------------
Rachel Rachel
------------------------------
Well, shoot. It allowed me to save, but didn't do what I wanted. I was able to create a duplicate record and I cannot set the composite field as key.
Is there a normal QB way to do composite indexes for a joining table?
------------------------------
Rachel Rachel
------------------------------
Is there a normal QB way to do composite indexes for a joining table?
------------------------------
Rachel Rachel
------------------------------
- The field just needs to be Unique to prevent dups, , not a key field. Double check it's set to Unique.
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
markshnier2@gmail.com
------------------------------- it worked now, and prevented the save. I must have needed to clear my cache or something.
Thanks again!
------------------------------
Rachel Rachel
------------------------------
