Create temporary table in VB6

[lfc1211]

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

[TcM]

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

[lfc1211]

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

[TcM]

Well to say the truth I have never dealt with Access table in VB.. So sorry if I was not of so much help.