I am creating a shipping label program in access 2002 which uses 3 linked read only tables from a sql 2000 server. In this database I have created 2 tables "tblLabels" and "tblLabelsTemp". The form I am using is for the most part complete and uses the tblLabels table. I have two combo boxes one for job number and one for shipto line item which auto fills certain fields from the 3 tables after update. I need to, after entry of the shipping record, create labels that are used on the cartons that will be shipped out based on the information taken from the 3 linked tables that are being saved the the tblLabels table. The problem is for each record I could, base on the amount of pieces in each carton, have to print multiple labels with a "1 of 2" or "2 of 2" scenario based on a field called total labels. I would like to know and be shown what would the easiest way to do this, should I populate the temp table with a count field and duplicate the records. Thanks in advance for your help!