Discount on order, dependent upon multiple order

[Chesney]

Hello everybody. Hope somebody could help me with a problem I have.

For each advert on my site the software provides me with info which I can convert to a CST text file, which I then import into a FM database. It works fine.

I want to be able to give a discount on adverts. The cost of the first one is

[Kurt Knippel]

Really all that you need to worry about is the first advert, this is the ONLY one that is different.

The first record in a self-relationship, will either be the ONLY record or just the first record. Either way that is the record that is charged the full cost. Every other record is charged the lesser cost.

[Ugo DI LUCA]

Kurt,

Let me walk on your toes a little, just to make sure he gets it working.

create a self-relationship from the eMailAdress

SelfJoin => Main:eMailAdress::Main:eMailAdress

Then c_Price = Case(Record_ID = ::SelfJoin:Record_ID, 25,15

Now, I have 3 different mail adresses, should I pay 25