I have a basic database with client's names, addresses and contact details. I want to be able to click on a name and go into an additional database with details of what they last bought, how much they spent and when they last visited us etc. Can anyone tell me if this is possible and if so how it can be done?
Thanks