Hi,
    I'm new to this forum, hopefully I'm posting this in the correct area.
So heres my issue. I have an xml file full of codes for my internet kiosk i generated (I can easily import into a pervasive sql database instead). I have my report all formated to my like and works great, except it prints all my records. I want it to only print one record, ok easy I change the select. But now the tricky part, I dont want the record to be repeated. So once the report is opened, I want the next record in my xml file opened.

My xml file has an index for each record, so I can easily use that value to base the select off of.

I've spoken with other techs in my department and came to the conclusion that it would be easiest to have a second database that has a list of used records. So when I open the report, it checks against that second table and finds a record on the first list not used on the second on.

Another way would be to delete the record on open of my report.

Both options are ok with me. So any help would be much appreciated. Thank you before hand.

How would I do that, sorry I'm new to XML.

Well I have several Internet kiosks at our resort. There is a central server that generates and exports the codes that you enter to get your time. You have to go to the front desk to pay, and they print out your code, my report. So I want it so two people arent given the same code, causing a money issue.

well our front desk software uses crystal reports. We want to incoporate this so it can affectivly be used with using room charges.

Essentially all we want is after the transaction, the report is oppened which displayed the next code in line. Our orriginal plan was to have them all pre-printed, then after the transaction grab a code off the stack. Unfortunantly our company policy states we can't leave inventory out at the front desk.