Jump to content

Just hitting my head against the wall


This topic is 7607 days old. Please don't post here. Open a new topic instead.

Recommended Posts

  • Newbies

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

Link to comment
Share on other sites

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:FmPro@home.com

http://www.database-resources.com

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

Link to comment
Share on other sites

This topic is 7607 days old. Please don't post here. Open a new topic instead.

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
 Share

×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.