Calculation Problem

January 31, 200818 yr

Hi, i can't figure it out how to this:

Part 1= Working ok

Check Box Set has 6 options (.com, .net, .com.mx, net.mx)

If i check .com in the domain kind: shows the provider, which is calculated by "case" formula.

This part it's working good.

Under this field (Provider) i have a field named "Domain Cost", if i select for example in the Check box ".com" the provider name = "GoDaddy", so depends on the privider has a cost.

The cost's are in another table, the relations it's by the field "Exchange Rate" in both tables.

So i'm using this formula to get the price depending on the typeof domain:

Case (Domain Proveedor="GoDaddy";COSTOS::Precio Domain GoDaddy pesos;Domain Proveedor="Nic Mexico";COSTOS::Precio Domain NIC .mx pesos;)*Domain Vigencia

And nothing happened.

Please help

Gian

January 31, 200818 yr

post your file

January 31, 200818 yr

Author

Here is the file

The layout i'm having the problem is:

Si Domain & Si Hosting

Edited January 31, 200818 yr by Guest

January 31, 200818 yr

Lets take this one step at a time.

I'm looking at the file, and I suggest that you use Radio Buttons instead of checkboxes on the Si Domain & Si Hosting Layout, that way they can only choose one of the options.

I'm not understanding (language barrier, I only speak english) what the different number Vigencia años are for, and how the are associated with the calculations shown below.

Lee

p.s.

Also, if you are a member of AIM, or one of the other chats, we could move faster on this.

Edited January 31, 200818 yr by Guest
p.s.