Data Entry Form

[Alec Green]

Hi,

I am wanting to create a simple sales data entry form, that shows all the
products on a form, so the user can just type the quantity required next to
the product, a bit like a lottery ticket shows all the numbers and the user
selects what is required. After a lot of thought the only way I can think to
do this is by having a massive table with all my products in, then linking
the form to the table. - There must be a better, easier way!

Any Ideas?

Thanks

Alec

 

[Guest]

Well you do need a table of products but what is the user indicating when
he/she enters quantities against prodcucts. Sales? purchases, orders?
If so, you will need another table for that, something like
OrderNo
ProductId --> links to Product table
Quantity

You will need multiple rows in this table per order, one row for each product

-Dorian

 

[Alec Green]

Thank you for the reply. Yes I understand that a table of products is
required, the form would be an order form, so the user can enter the
required quanatity of products that is required by each sales order.

Thanks Again

Alec