I would suggest you to make only one column for batteries that is a lookup from you battery column in the battery table.
Then you would have another column next to the lookup with the quantity.
In your battery thanks in the quantity field you add formula : Toys.filter(thisrow=thisrow.battery.totext()).sum
It’s possible that my formula isn’t completely right
Create a “Battery Types” table with the type of battery listed in the first column. Then create a “Toys” table where you have the name of toy and where the “Battery” column is a Lookup from the Battery Types table. This will let you sort and filter easily and keep things consistent.
Then back in the Battery Types table, create a “Total Needed” column and add the formula:
These are all great responses. It’s possible that some toys could take multiple types of batteries. I don’t have any at the moment that do, but that could change. For instance, if I was to get a remote controlled car that took AA batteries for the car and AAA batteries for the remotes.
Thank you for all of your suggestions; I appreciate the time you have taken to assist me.
I do have sums on the “Toys” table, so this is not necessarily something that I NEED. I’m just curious to see if it could be done and to learn the process for working something like this out.