query on table

[vodnalar26]

I have a requirement in a custom table with three fields: Model Category, Model, and Location.
The form should guide users to fill these fields in a specific sequence:

1. First, the user must select Model Category
2. Then, based on the selected category, the user can choose Model
3. Finally, the user should select Location

I want to configure this in a user-friendly and controlled way so users cannot skip the sequence.

How can I make?

[Ankur Bawiskar]

@vodnalar26 

you can't force but then why not show the 2nd when 1st is populated and show 3rd when 2nd is populated?

you can handle this using onChange client script on 1st and 2ne field

💡 If my response helped, please mark it as correct ✅ and close the thread 🔒— this helps future readers find the solution faster! 🙏