Hello Gurus!

I need your help again...Here is my situation:

-On a Search.htnl I have raio buttons set to 4 Locations. When one is selected I get these results just fine:

Location | QTYTotal | AmountTotal|

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

CA | 3| $60.00|

My goal is to have an additional 5th radio button that will hold the value "All Locations" so when checked I would get the follwoing (all) results:

Location | QTYTotal | AmountTotal|

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

CA | 3| $60.00|

NY |4 | $80.00|

MD | 7 | $140.00|

So my question is how/what value to assing the button "All Locations" to compleate the search as mentioned? All three fields are in the same DB!These QTYTotal and AmountTotal are summary fields but if I select an empty value for All Locations it return Totals for ALL Locations together not each one separatly.....what to do...is this a DB design flaw?

Thank you guys!

I know how this can be done using a hidden field and JavaScript... How familiar are you with JavaScript?

somewhat.... I can go throught it and get the concept but writing it myslef is a bit of a problem...unless we talk about rolloevers LOL

so what would be the code?

thanx

so Addam......

how about sharing that knowledge?

Looks like something which can be handled with simple CDML. Display 3 fields from found records set.

[FMP-Record][FMP-Field:Location][FMP-Field:QTYtotal][FMP-Field:TotAmt][/FMP-Record]

set in a table.

There is probably at least one example of this in the SampleFiles forum.

that IS what I am using but that returns:

Date|Location | QTYTotal | AmountTotal|

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

1/1/02 |CA | 3| $60.00|

2/2/03 | CA| 6| $120.oo|

when one Location is selected on a search page.

What I need is "All Locations" selected. Location is a field that has 5-6 possible locations entered. If none (all)selected I get:

CA....

NY...

MD...

CC...

MD...

WY...

WY....

I gues what I am sking is how to NOT display the duplicates?

I gues what I am sking is how to NOT display the duplicates?

that IS what I am using but that returns:

Date|Location | QTYTotal | AmountTotal|

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

1/1/02 |CA | 3| $60.00|

2/2/03 | CA| 6| $120.oo|

I'm sorry, what are the duplicates? You have records for two very distinct months and years.

This probably has something to do with your search parameters.

ok my mistake.....

when a user types a date range or a single date and searches lets say for : date:1/1/02 AND location "LA" (multiple records are made on this location on this date) I would get this:

date|Location|TransactionAmount

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

1/1/02| LA | $120

1/1/02| LA | $50

1/1/02| LA | $170

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

TOTAL: $340

all this works great when only ONE location is entered/selected; If I select "ALL Locations" the list returns with ALL locations and total of ALL of them not the each location individually (hm...now that I said it..it might be the DB..anyhow)

what I would like to see:

date|Location|TOTALtransactions

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

1/1/02| NY| $56000

1/1/02| CA| $5000

1/1/02| WE| $17000

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

this post has been answered on cross post:

http://www.fmforums.com/threads/showflat.php?Cat=&Board=UBB12&Number=60382&fpart=1&PHPSESSID=