Lookup & add multiple records from a child table and add them to a parent table record
Hello Quickbase community!
I'm stuck on trying to build a configuration where I can lookup & add multiple records from a child table, and add them to a parent table record.
I have a primary table, Films, full of Film records. I used to have tags/labels for these records that I kept in a multi-select text field, but I now have more than 100 values, so I needed to create a related table. So, I created a new table, Categories.
What I'd like to do is be able to add multiple Category records to one Film. I was able to figure out how to add 1 Category to each Film, but I wanted to be able to add 2 or more. In my screenshot, my Film record, 'Spider-Man: Brand New Day', has the Category record 'Franchises' attached to it. I also need to add the Category records 'Spider-Man', 'Actor | Tom Holland', and 'Actor | Zendaya' to the Film record. Shouldn't I be able to click a button (based on a Formula URL field) to add records one by one, which will then display in a mini table of related records?
Thanks in advance!
np, but the set up you actually need is what's called a many to Many Many join table called "Film Categories".
The setup is that
One Film has many Film Categories.
One Category has many Film Categories.
When you set up that joint table, you may find it a bit strange that you don't actually need to initially create any fields on that table. When you create the relationships, you will bring down the field name for the film title as a look up down to the joint table and you also bring down the category name as a look up down to the joint table. Then on the films table, you would include in a better report of all the categories. And conversely, you can do the opposite. You can have a list of all the film films on the categories table.
Then you can also use a combined tech summary field on the category name to roll up all the Categories up to the parent film table if you want to be able to use them on reports and there's not a crazy high number of Film Categories.
Once you have that set up in place if you find it way too slow to add these film categories one by one there are some techniques to make that go faster, but one step at a time .....
