Ticket ordering system

[ToonvK]

I have a website on which people can order tickets. This results in a csv file I can import into MS Access.

I've got the following fields:
Name, address, etc. and of course how many tickets are required and I will give them a unique order number..

But now I need a way to add records in an existing separate ticket table in order to be able to print the tickets and later keep score how many "tickets" have been attending.

So the input is this in a table:

Ordernr	Name	Address	Ticket total
ORD240015	John Doe	Graveyardlane 1	6

After the query or whatever the result will be:

Ordernumber	Ticket number	Ticket total	Unique ticketnumber
ORD240015	1	6	49
ORD240015	2	6	50
ORD240015	3	6	51
ORD240015	4	6	52
ORD240015	5	6	53
ORD240015	6	6	54

Already processed orders do not need to be processed if ordernumber exist in tickets table.

Who can help me?

 

[Gasman]

Please do not crosspost, especially on the same site.
Why is the other thread marked solved?

 

[ToonvK]

Hi Gasman,

When I submitted the first one I saw it would have been better to make use of tables.

So I wanted to change that.

Then I saw that the origional screen was still open, so I altered it, wanted to save it but couldn’t, so I pressed submit, inadvertently submitting a new tread.

Now to be sure I only get answers to the right thread, I stated it solved.

But if you are able to kill the solved post, please do so, because that’s what I wanted.

My excuses for the inconvenience.

ToonvK

 

[Gasman]

For the future, there should be delete option visible.

 

[The_Doc_Man]

I will remove the "Solved" case for you. Moderators can do that.