I have got myself into a mess regarding what should be a pretty simple setup, any pointers are appreciated.
Customers can have several products (type A or B)
The customer can be Husband and Wife (team) but may have a product together or separately
A team will be allocated a specific team number...
I am about to create a system where I want to use MS Access for data and MS Outlook for email,contact management etc. I have a dilemma (what do I use for storing the contacts)? I know I can use Access and use VBA to send emails etc but I also want the user to be able use Outlook directly to send...