I'd be willing to share a little of my knowledge...
That would be really helpful Brent. How would I get you the file to have a quick look at? I could then send you just 2-3 small things I need help sorting out?
I do. How can I share a folder with you?
Did that work? This is just a template I am working on.. but if you can help..
Basically this is all about linking consignments, artworks and clients in a way that actually works. So far artworks and invoices works fine but consignments is more difficult as artworks can appear multiple times in that table. On numerous consignments, to numerous clients. Obviously when an artwork is invoiced you only sell it once (to one person!)
Things I am trying to achieve are -
1. In the consignments section, I need to be able to link the table properly to my contacts / clients table. So that consignments appear in a list in the consignments tab in contacts. Like the sales tab works when you invoice an artwork to a client.
2. Most importantly, I need to be able to create new records in consignments and be able to add add the same artwork in two records. At the moment because of my scripts I think, you can only have the artwork in one consignment.
3. It would be great to link consignment details to the main artwork pages too. I'd have to create a new table along the bottom row and add a consignment history area. Like the Sales history tab works.
Obviously any more general suggestions for the way things are mapped out and working would be great too.