How to buid an aaplication for sale of books

[Ayiramala]

Hi,


I want to build an application for sale of text books in my school. This is what I have done so far: TI created a table tblStudents with the names of students and their classes, and another table tblTextBooks with the titles of books and their prices. My idea is to use a continuous form with a lot of check boxes against the student names. Each check box for each text book. You tick all the books that a student ordered.

How do I do this? How do I set up the check boxes?

Also, some people say that it is better to avoid a continuous form for data entry. Is it alright to do it? It will be very convenient.

Any help is greatly appreciated. Thanks.

[orange]

Do you have a description of your business? You want to sell Textbooks. Are there different kinds of textbooks?
Are interested in the Publisher or Author? Are there new and used textbooks?
I think you may also want a Sales table which would hold info about a Sale. Is it possible that a Buyer could buy multiple Textbooks in 1 Sale?

It is very important to identify all aspects of your proposed business so that you can determine all of the information necessary for that business. Also if you model your business data requirements, you can test your model to ensure all the data you need is available. If you have a model and some sample data, you can create a "test scenario" and see if you can complete the scenario and get appropriate results/info from the data model. You can adjust as necessary until it works as planned; then build the real data base.

Here is a free generic data model re Inventory and Sales. It may not represent your situation, but it is generic and is meant as a guide --use all or part and/or adjust as needed to match your situation.

Good luck with your project.