I need to know how to populate a join table with all the possible records from one of its parents. I assume I need a script.
I am creating a restaurant inventory database. I have multiple restaurant locations in a Restaurant table. I have multiple products in a Products table. I have a join table to record the inventory level of each product at each restaurant. I have a layout for the restaurant with a portal that points to the join table. I would like to create a button on the layout so users can quickly add all the products to the join table, and then they can easily enter the inventory quantites in the portal. Any suggestions?