AnsweredAssumed Answered

Script to populate a join table with all the records from one parent

Question asked by tomchandler on Feb 27, 2014
Latest reply on Mar 1, 2014 by tomchandler

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.

 

Specifics:

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?

Outcomes