AnsweredAssumed Answered

Data source issue/connecting two databases

Question asked by BrandiClark on Oct 10, 2013
Latest reply on Oct 10, 2013 by philmodjunk


Data source issue/connecting two databases


     I have created an inventory database and a contacts database that I would like to create a relationship between. When a client makes a purchase, I would like to add the item to their record and have their name automatically add to the item's page, so we can see who purchased a piece if we need to look it up for some reason. 

     The problem I have encountered is that the contacts database does not show up as a data source when I attempt to make the relationship. 

     Is there a secret to adding the contacts database as a data source or do I need to build it a certain way from the inventory database? I've been working on this for a couple of days, and i don't seem to be getting any closer. Thanks for your help!