Hi, As requested on my question at Youtube , I will put it here.My question is related to the video of cascading comboboxes introduce in August last year. These comboboxes are all in relation to each other. However in the application that I have in mind, some of information (records) will be deleted in the future due to the certain events. So when you delete a record your database will only show a number but you may never find the 'description' of that number again. So my question is can you do this cascading also without relations so that in the end only your plain selection will be in the database. (Pff maybe confusion explanation but I hope you get it).
Kevin Robertson
@Reply 3 years ago
There has to be some sort of relationship between what's selected in the first Combo Box and what is displayed in the second Combo Box. If not, how do you determine what to display?
I would mark those records inactive and only show active records in the Combo Box.
See this video: Don't Delete Data
You can use cascading combo boxes to make a selection and then save that final selection text in a text field. For this you would need an after update event tied to the last combo box. After Update
Sorry, only students may add comments.
Click here for more
information on how you can set up an account.
If you are a Visitor, go ahead and post your reply as a
new comment, and we'll move it here for you
once it's approved. Be sure to use the same name and email address.
This thread is now CLOSED. If you wish to comment, start a NEW discussion in
Visitor Forum.