Products Table

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have 9 products in my products table list. I want to create a sales table
where all of these products will be shown so that I can enter sales for each
one. I do not want a drop down list as I have to enter figures for each
product every day. Any help on this will be greatly appreciated

Many thanks
 
one way to allow for easy data entry while adhering to normalization rules
in table design, without a lot of programming, is to create a main form from
which to control the creation of "daily sales" records for all the products
in a subform - perhaps by clicking a command button - and then enter the
sales figures for those existing product records, in the subform. it's quick
and easy, pretty much like running down a pre-printed paper form and jotting
down the numbers for each product.

if you're interested in that approach and would like more details, post
back.

hth
 
Hi Tina - thanks for your post.

Yes I think you may have the solution to my problem - I want to input daily
sales for each salesperson/location but I want to have the fields for each
product showing so
I will only have to enter the amount sold of each product. I would
appreciate any instructions to set up such a method.

Thanks
 
okay. the setup is easy enough, but i always find it hard to explain in a
post. i threw together a quick demo that shows a basic form/subform
solution, in A2000 file format, and loaded it to my website. if you want to
take a look, go to http://home.att.net/~california.db/instructions.html,
scroll to the bottom of the page, and click the "demo" link. the file has a
..bak extension, so *make sure you change it to .mdb BEFORE you open it in
Access*.

hth
 
Thanks Tina - I downloaded the file and changed the extension to .mdb but
Access gives me a security warning and even when I opt to open the fiole it
says Access cannot open it because of Security problems

Please let me know how I can open the file

Many thanks
 
hmm, well, if you're using A2003, try opening Access and on the menu bar
click Tools | Macro | Security, and on the Security Level tab select Low.
(if you're not comfortable with a Low setting, you can always change it back
later.) then click OK and try opening the db again.

hth
 
Ok - I got the file opened - had to right click file and then in properties
click on unblock.

This is exactly what I was looking for - very many thanks indeed. Now I can
proceed to the next step in the creation of my masterpiece! Thanks for
opening the door for me - I had been stuck at this stage for a while.
 
you're very welcome :)


Mark Fordham said:
Ok - I got the file opened - had to right click file and then in properties
click on unblock.

This is exactly what I was looking for - very many thanks indeed. Now I can
proceed to the next step in the creation of my masterpiece! Thanks for
opening the door for me - I had been stuck at this stage for a while.
Click to expand...
 
Back
Top