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!