hi im new to all of this and have a problem thats why im here

I am trying to right a fm doc that will keep track of american airlines customers who we give mile credits to

so for what i am able to do is

enter customers

their id codes and all

have that refer to a payment page which is by the month and year

and have a running total for each of the customers

the part that is the prob is that each month a payment is added and i need to have a voucher code that is in order per each transaction for each of the customers accounts

so if anyone wants a problem to solve ill be checking this every day

thanks

fc

quote:

---

Originally posted by macuser:

the part that is the prob is that each month a payment is added and i need to have a voucher code that is in order per each transaction for each of the customers accounts

so if anyone wants a problem to solve ill be checking this every day

---

So are you looking for something like:

CustomerOne gets codes 001-001, 001-002, 001-003, etc.

CustomerTwo gets codes 002-001, 002-002, 002-003, etc.

CustomerThree gets codes 003-001, 003-002, 003-003, etc.

If so you could have a code for each customer which starts the voucher number then a voucher sequence code which ends the voucher number. Then simply increment the voucher sequence code by using a self relationship to the file by CustomerID.

(i.e. Auto-entered data, VoucherSeqCode = Self by CustomerID::VoucherSeqCode) where the Self by CustomerID relationship would be sorted by VoucherSeqNumber in descending order so that that highest number is the first record.

Now, of cource there is a bunch of different way to do this, so do not feel that this is the only way to accomplish this.

------------------

=-=-=-=-=-=-=-=-=-=-=-=-=

Kurt Knippel

Consultant

Database Resources

mailto:[email protected]

http://www.database-resources.com

=-=-=-=-=-=-=-=-=-=-=-=-=