AnsweredAssumed Answered

Relationship problems

Question asked by BrandiClark on Aug 3, 2013
Latest reply on Aug 4, 2013 by philmodjunk


Relationship problems


     Hi - 

     I manage an art gallery, and I'm trying to create a database that will allow me to track both our sales and our inventory. I have built two databases - one for clients (or contacts) and one for art (or inventory). I would like to be able to track client purchases within their record, so when we close a sale, we can enter the sale date and inventory number, and the artist's name will automatically populate. I would also like the sale date and contact's name to populate on the inventory page. I set up a relationship between the contact and inventory tables as "inventory # = inventory #", but it doesn't seem to be working. Any help is appreciated - thank you in advance!!