ONE
I have a table , suppliers, (created a form)
I created a combo box for the supplier ID, now when I select a supplier from there, how to I update all the other fileds in the on the form ?
TWO
I created a form, where the user selects a employee name from a combo box, ondoing so, it updates a list box which containts all the suppliers the employee can use...
want i want is to create a button, so when you click on a supplier from the list box, you can DELETE it...
I have another combo box, where it has all the suppliers, from the supliers table on the same form,
what I want is a button which add the supplier to the employee selected from the combo box....
my tables are like
employee - A Link table - suppliers
if someone can point me to the right direction?
I have a table , suppliers, (created a form)
I created a combo box for the supplier ID, now when I select a supplier from there, how to I update all the other fileds in the on the form ?
TWO
I created a form, where the user selects a employee name from a combo box, ondoing so, it updates a list box which containts all the suppliers the employee can use...
want i want is to create a button, so when you click on a supplier from the list box, you can DELETE it...
I have another combo box, where it has all the suppliers, from the supliers table on the same form,
what I want is a button which add the supplier to the employee selected from the combo box....
my tables are like
employee - A Link table - suppliers
if someone can point me to the right direction?