Sales total

[Samantha Mattie]

I'm trying to figure out how to imcorperate one database we have for clients orders into another. What I'm trying to do is, taking the items they ordered and have another database to keep a running track of all the purses, bags, totes we sell. I want to have on field for purses with the total of all the purses we've sold, and so on, then at the end of the form have a total of everything we sold. How do I take the information (Well part of it) from one database and stick it into another without repeating layouts.