Not getting updated values in table columns

[Nav-Chouhan]

I am having a customer table at which there are 3 columns city, state, and country. Unfortunately, when we create a new record or update a record these 3 columns are not having their values init.

I am using the select_from_array custom field for state and city fields. Basically, state and city fields are dependent select box. When Country gets selected an ajax call trigger to get the state records and populate the state dropdown. The same is happening for the city dropdown it gets its value when the state gets selected.

For more details please have a look at the attached images:

Also, Would like to update you that when I debug it and check the request parament after the form post I found the values are appearing properly.

And after the update command

Please guide me on what exactly happening here.

Thanks In Advance

[promatik]

Hi @Nav-Chouhan!

I see many issues in your code;

1. Models should be in singular form, so Costumers » Costumer, Cities » City, States » State, Countries » Country.
2. When you have relations, you should use _id, so city » city_id, state » state_id, country » country_id.

Internally, some of this things would make the relations to be saved automatically, you need extra setup if you don't follow the standards.

I think the issue may be in the definition of the belongsTo relations, since you're not following the standard, you must set the column name there $this->belongsTo(Categories::class, 'category');

BUT, it's highly recommended to follow the standards, instead of fixing this inconsistencies every time they happen, otherwise you'll keep on having more problems in the future.

[Nav-Chouhan]

@promatik Thanks for highlighting the bugs. I have changed the code according to the standards. Now of fine.

Thanks Again :)