Hi,
I have designed my own database for my business and been using it for the last 4 years, but there is 1 thing I want in it that I can't fathom how to do.
I have a customer table and orders table and I work on 3 weekly rotations for brochures, but I want to record who I have taken a brochure to each rotation (i.e each rotation is listed as a year and rotation for the fields) in the orders table, I have the fields for this in the table but at the moment I have to click on each customer (from a search form) to put the information in which takes time and is monotonous!
What I would like is to show a list of all customers grouped by year then rotation and be able to put in next to each customer if they have had a brochure and if I got it back (the latter is useful for when I re-canvass), I will also do it so that I am able to put the value of any order in.