admin wrote:
Well, if you don't know, how could I...
looks like $city is empty at the time it looks for the country name. But it's saved in db, if i edit this item again, then it finds the $city and can find back the $country.

Can't you filter by both...?

Do you mean a filter a grid or in a specific function?

You will be able to filter directly by country very soon, once I've finished to implement better filters on different levels.

A detail
In the model, you can write in save(), but it is not the best.

The function in the MODEL is : prepareTable() Where the wizard are written.
This is why it has been confused with prepareQuery()
Now I understand ... I am very tired...

a grid.
No i can't filter on country as country is not saved

admin wrote:
I use the "store" function in tables, not the prepareTable in model, which doens't even exist here, because i chose to put automatisms in Table

Just to check if I'm understanding correctly...

I have tables: countries & counties (states)
Countries have a name
Counties have a name and a country

I also then have a clients table with a county field... When new records are created here, I filter the counties on Countries using ajax checkbox in the options. Also, in the grid combo filter, I do the same... So, I first select a country then a county. Works perfectly...

Is this what you mean?

Gez

It works, but it only saves the value of county. So i can't filter on country alone, i have to choose a county too, which is not what i want to do.

Ahhhh, right, I get it...

Isn't there an option to submit after each group in the ajax filters? Sure, I understand that this would still produce a city combo in your case but, that doesn't matter does it?

I mean, in the first select, results would be filtered by country???

Gez

Last time i checked on this, it wasn't functional (three weeks ago if i remember ok)

I'm sure I had it working...

Hold on I'll check now

You're right, it doesn't work...

Theoretically speaking, this should be as easy as making sure that the right joins are in place to travers back up to your country. Practically speaking, I'm not sure how to do this as I've not dug into the code for the ajax combo.

That said, I think that this is something that would be better changed at the core of the combo code as opposed to in any of your component's classes.

Well, the thing is urgent so, even if it is not elegant, even if it's not the best solution, i would like to get back to my initial request : i want to be able to save the country in another field, but it doesn't work for some reason.

OK so,
In the save function, shouldn't you target the city value with $data->city as opposed to $this?

I use the store function in the tables folder.
using $data->city doesn't work

OK... Try this:

$maDB->setQuery ("SELECT c.id FROM #__xxx_countries as c WHERE c.id = $this->city");