www.hkvforums.com

How do i bind a combo box to multiple tables? i have different types of services (e.g Land table, rent table, sales table) but all the payments for these services are saved in one table (payment table). I want the combo box to bind to a single table at a time based on the type of service selected for payment. If am making payment for land it should bring only land table. Please Kindly help.

You can create a view to join the tables and use this view as lookup table. Then, you can create a parent filter to filter the option. See the Dynamic Selection List feature in the help file for more details.