Create temporary table in VB6

#1
Guest_lfc1211_*

Posted 10 May 2007 - 08:26 PM

Guests

Anyone have any idea how to create a temporary table in VB6

I am building a restaurent ordering system which i need one temporary table to store the orderdetail once the user click print bill only that the orderdetail inside the tmp table will tranfer to the order database

#2
TcM

Posted 11 May 2007 - 04:23 AM

Writes binary right handed and hex left handed

Members
11,147 posts

So you want a table to be displayed and then the table to be hidden?
If yes, then why not using the .visible = false?

#3
Guest_lfc1211_*

Posted 11 May 2007 - 11:23 AM

Guests

thank for your help but the table i mean was the one in mircosoft access. I need it to store the order detail the step work like this

1. The user key in the order detail into the specific Order ID

2.Before the customer pay the bill the order can be extend and retrieve other order from the same customer. Inside the order detail there maybe multiple item ID. Which mean that one orderID can have multiple OrderDetailID and multi Item ID.
(so here is where i need the temporary table to store the order detail)

3.Once the customer pay the bill while the Print bill button is click the specific order will be close and transfer to the ordering table which will be use to calculate the sales total of the day and be references for the future.

thank for viewing and helping me to solve this problem it is the first time for me to deal with this situation in VB