I have a [url removed, login to view] Program that I am writing and need some help with. The backend is SQL Express 2008 and the frontend is [url removed, login to view] 2008. I have a form to input a ticket. On the ticket form are some combo boxes. Whenevery someone selects a customer from the combo box I would like to populate the Jobs listed in the Jobs Table with that customerID to a separate Combo Box. Whenever Someone selects a Pit from a different combo box. I would like to display the products associated with that Pit. There is a Driver Combo Box and I would like to populate the that combo based on the Employee's Table where the Driver field = "Yes".
I have all Tables created and the Source for everything. You do not have to write anything to the Database just populate the Combo Boxes and I will do the Rest. Any Questions Please Contact me and I can send you a screen shot so that you can better understand.