Hello there,
I had create a form and I would also want to include a combo box as a data selection/filtering option. I layout my database in such that it will have a master table containing every piece of information and also a lookup table for profession. Both the lookup tables are available in the master table and as part of the master informations.
Based on the above layouts, I would want the combo box to function in such that the data source for the combo box will refer to the lookup table and upon selecting any of the listed data, it will returns any correctly matched informations from the master table.
Thanks
Law
I had create a form and I would also want to include a combo box as a data selection/filtering option. I layout my database in such that it will have a master table containing every piece of information and also a lookup table for profession. Both the lookup tables are available in the master table and as part of the master informations.
Based on the above layouts, I would want the combo box to function in such that the data source for the combo box will refer to the lookup table and upon selecting any of the listed data, it will returns any correctly matched informations from the master table.
Thanks
Law
