Adding records to another table from the currnet table

[Stan Lobunets]

Hello,

Is the following possible? I need to display a grid of records, with one of the field in a row being a checkbox (like in Frank's Shopping cart example). After I tagged the records I like, I need to create a report based on their values. In effect, it's the same thing as generating an invoice for a shopping cart. Please somebody let me know if it's possible, it's a very important feature on our application. I am very new at ASP or VB, and I think ASPdb is great, but I can't afford to spent my time on it if I can't implement this feature.

Thanks much

Stan

[John]

Hi Stan,

Is the shopping cart example you're referring to the one at:
http://www.aspdb.com/shoppingcart.asp ?

When you click on the "Enter your order" button, it effectively "prints a
report" that displays which items were ordered & which ones you checked
the "Overnight Delivery" boxes on. With a single line of code, it could
skip showing the table again and just show the results at the top once
you've clicked the "Enter your order" button.

Doesn't this show what you want to do?

John


On 11/2/98 3:58:03 PM, Stan Lobunets wrote:
> Hello,

Is the following possible? I need to display a grid of records,
> with one of the field in a row being a checkbox (like in Frank's
> Shopping cart example). After I tagged the records I like, I need to create
> a report based on their values. In effect, it's the same thing as
> generating an invoice for a shopping cart. Please somebody let me know if
> it's possible, it's a very important feature on our application. I
> am very new at ASP or VB, and I think ASPdb is great, but I can't
> afford to spent my time on it if I can't implement this
> feature.

Thanks much

Stan

On 11/2/98 10:46:08 PM, John wrote:
> Hi Stan,
>Is the shopping cart example you're referring to the one
> at:
> http://www.aspdb.com/shoppingcart.asp ?

Yes, it is.

>the "Overnight Delivery" boxes on. With a single line of
> code, it could
>skip showing the table again and just show the results at
> the top once
>you've clicked the "Enter your order" button.
>
>Doesn't this show what you want to do?
>John

It does, however I need much more handholding than that

Here's an example of what I need to do. Suppose I have an Access database with a Scores table with fieds: id, num1, num2. I need to display that table in grid mode, with a checkbox next to each line. If a record is tagged, I'd like to create a formatted field names with averages of num1 and num2 fields on the bottom. How would I do that? Again, thanks for any help.