how to create a report for continues form

[honar]

I am working on a fast food restaurant database, one of the forms is a continues form that I use for entering sale information such as type of food, quantity, price ,.... what I want to do is to create a report for the current displayed records of the continues form to make a recipe for the customer. can anyone please help me to do that?

[twinnyfo]

honar,

It sounds like you are asking for the final product, rather than assistance on a particular point.

However, I think the key to your approach will be to have a ReceiptID that manages all the items on each receipt. Then, printing a Report that is built on a ReceiptID should be fairly straightforward.

Perhaps there is something beyond this that has not been explained?

[honar]

twinnyfo

my problem is when the form is open and I entered one more records, I want to make a report for those records only, how I know which records to get from the table and put them on a report?

[twinnyfo]

honar,

The answer to your question has less to do with reports than it has to do with table design and structure. For example, if you have a table tblReceipts, it should have a primary key and list the date of the receipt and maybe a few other generic bits of information like who took the sale. These data are specific to the entire Receipt. Then, you have another table with Receipt items. It uses the primary key from tblReceipts but each record is for a single item. It may include other things such as the cost for each item or the number of items.

So far, we haven't talked about reports or forms. However, when your tables are designed this way, your forms naturally fall into place and when you create a report (one receipt), you filter by the Receipt ID, and only the items that apply to that receipt are displayed.

I don't know your experience level with MS Access, but these principles are foundational to good DB design.

Again, I think you are asking for more than assistance with a small sticking point. I think you need additional training in the basics of DB design. We've all been there at one point or another.