Newbie Help pls: Cascading multiple Combobox from different tables
Hello there everyone. Hope you can help me.
I am new to this forum and have little knowledge on Database programming. I am trying to cascade multiple combox box from different tables and populate it to a text box to be saved to a table but i am unable to populate and save them. I have searched the forum but unable to get it.
1) in a form, I will select a supplier code and that will populate the description. the description will then be saved to the Supplier name in the tblpayment.
2) on the same form, I will select from the combo box Level 1, 2 or 3 and I want the description to populate either for Level 2 or level 3 (if the Level 3 is blank/Null). the description will also be saved to the field in the tblpayment.
I am attaching a screenshot of what I have been doing.
Hope to hear from your guys. Thanks a lot in advance.