Products Table

[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

 

[tina]

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

 

[Guest]

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

 

[tina]

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

 

[Guest]

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

 

[tina]

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

 

[Guest]

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.

 

[tina]

you're very welcome

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.