Small Gallery Organizer Pro

I downloaded your free trial Organizer Deluxe. Before I purchase your product for our business, I need to know if it can perform a few different tasks. We are an art gallery with a large inventory and a large database of clients. We want to keep the inventory and contact databases separate, but connected. For example, if we sold four different pieces of art by four different artists to the same client at different times, would it be possible to connect the inventory of each sold piece to a single contact record? We want to be able to look at a contact record and see the different artworks that they have purchased. Or we want to look at an artist and see all the different clients that have purchased their work. How customizable are the list reports? Basically, can there be two different databases open at the same time, sharing some information? Any help you may have would be appreciated

Open Contacts database, click Purchases or Artworks tab, all purchased items are displayed:  art gallery contacts database