AnsweredAssumed Answered

newbie! creating multiple records from single record

Question asked by ohlittlejeannie on Mar 13, 2012
Latest reply on Mar 13, 2012 by ohlittlejeannie

I have a Table named Royalty Percentages with fields: Item Number, Royalty to, Royalty Percentage. Each item number has 1-4 records, depending on number of individuals who are paid royalties for the item.

 

I have a second Table named Net Sales with fields: Item Number, MonthYear, Net Sales. There will be one record for each item number per month.

 

I want to create a table of Royalty amounts to be paid each month. I am, apparently, a terrible script writer. I am also about to lose my mind (what's left of it). Anyone want to come to my rescue? Thanks!

Outcomes