Hello Everyone,
First off, sorry as this is all most likely going to seem very elementary, but I am having trouble with the access database that I am trying to build. I am reasonably computer savvy but also quite new to access. What I am trying to do is build a system for our (small) company, and making it in such a way that once it is finished, everything can be achieved using forms, for the people who might have more trouble. I have been reading some books, searching forums, doing tutorials etc, but am still stumped.
We offer chemical products to our customers are to be used weekly, and what I want to produce is a way to be able to build them a program/report in access that tells them what to use when, something like this:
JAN:
Week 1:
product 1
product 2
product 3
Week 2:
product 1
Week 3:
product 2
product 3
Week 4:
product 1
It would have this for each month for a year. I would like to create a form where I can first add a client to the database, and then have a second form that first has a dropdown list of the clients at the top, and once a client is selected, I can build and edit their list of products and yearly plan, and then print a report for them. There is also going to be some chemical calculations, prices, etc, but I think once I have figured this part out I should be good to go.
Sorry again, I know this is incredibly long and most likely obvious, and thanks for your help in advance.