Could someone take a quick look at the sample DB I've attached and give me some advise to my problem.
Form 1 is set-up as I wanted, I thought I had everything linked right, but now I am getting an error everytime I use the controls on the form.
I also know that I have a huge issue with my DB structure.
The form simply is a data input tool for us to track distribution of products by account. I'm sure there is an easier way.
The next steps for me on this project is to link sales data ( by account)and compare against the authorized items. If an item is authorized but shows no sales, I know we have a distribution issue.