Gleep

Why don't you just make different layouts for different departments...that way they are still manipulating the same file? That's what we do here. When we take an order from a "Professional", who needs an invoice, our manager just pushes the "invoice" button (simple go to layout button) and the information is organized to look like an invoice....but its still the same information. I am however new at this but I agree that you do not need 6 files.

We use a portal that links our invoice to a line items file. I am trying to design a new layout for the invoice right now and am having a problem printing. The fields in the portal somehow block out the lines seperating the rows in the portal. This is a customer receipt that ships with thier invoice so I would like it to look as professional as possible. I have tried every setting I could think of but I must be missing something. Any ideas? The wierd thing is the portal is 18 lines deep, and the formatting only gets screwed up about 7-8 deep.