G
Guest
Hi,
As tours are sold at the various hotels, we need to provide "vouchers" to
the customers which they will give to various service providers during the
tour. We want to number these vouchers with sequential and unique numbers.
Initally I thought of a table of vouchers with an autonumber primary key
(VoucherNo), new records being added by "Append query", BUT, looking through
this forum's postings, I was discouraged from using Autonumber. Also,
wouldn't I have contention problems for voucher numbers when many hotels
started printing vouchers at the same time ?
Also I couldn't get an Append query to add rows to the Voucher Table, using
the autonumber primary key.
Comments and ideas for general approach, will be greatly appreciated.
TIA,
Charlie
As tours are sold at the various hotels, we need to provide "vouchers" to
the customers which they will give to various service providers during the
tour. We want to number these vouchers with sequential and unique numbers.
Initally I thought of a table of vouchers with an autonumber primary key
(VoucherNo), new records being added by "Append query", BUT, looking through
this forum's postings, I was discouraged from using Autonumber. Also,
wouldn't I have contention problems for voucher numbers when many hotels
started printing vouchers at the same time ?
Also I couldn't get an Append query to add rows to the Voucher Table, using
the autonumber primary key.
Comments and ideas for general approach, will be greatly appreciated.
TIA,
Charlie