First of all, my Access is written in Chinese, but ill try my best to illustrate my question
-------------------------------------------------------------------------------------------------
Table A Import ingredients ----->Form I
Table B Import Details ----->Form II
Table C Ingredients Details ----->Form III
Table D Supplier Details
Relations:
Table D 1--------∞ Table A 1--------∞ Table B
Table D 1--------∞ Table C 1--------∞ Table B
------------------------------------------------------------------------------------------
I Got a Form I (Table A) that contains a sub-form (Table B)
User insert date/ branch/ supplier on the boxes above (belongs to Table A), and insert Ingredient name / price/ number in the sub-form. (belongs to Table B)
The 1st column in sub-form ( name of ingredients) are link to Table C which hold all ingredients details. I create a combo box so user may select.
The problem is, when the list gets too large, user will find difficult to find the right ingredient. (since Chinese character can't sort in alphabetical order)
The solutions i came up with are:
1. Apply filter within the combo box (in sub-form : ingredient): Since user previously select the "supplier" in the combo box above, is there a way to filter out other ingredients which aren't link to the supplier
2: Introduce search feature: I create Form III(Table C) which allow user to search ingredient through typing. (I wrote macros within the button).
The problem is, how do i pass the selected data from Form III back to Form I (inside it's sub-form)??
I am still learning Access while making this, so any suggestion will be appreciate. Thank you.