I have a form I got at work. that I invoice my company. Scan the form. Put it in a report and put the fields over it and print. Thats the Goal! Okay the problem. I have 17 customers I can invoice at once and 16 pay codes that are in colums with the customers going down the left side of the page and the 16 pay coded spanning accross the top. I know you can't have over 255 fields in a table. I first tried to put the customer field in then the 16 codes in one record. Worked however couldnt format it correctly using sorting and grouping in the report. So I then tried to split into two tables. customer 1 through 8 on one table and customer 9 through 16 on the other. Then had a form with 1 through 8 and a subform 9 through 16. CustomerID being the primary key on the main form (autonumber) and customerid on the second form being a (number). when I created the subform it linked child and master to customerID. However when I went back to look at the form it didnt syncronzie with the main. however, it did show the other 9-17 customer records in the table. Question: Can this be accomplished and if so, how? or did I miss something on the "on format command" when trying to do it the first way i mentioned. Thanks.