Hi,
I am fairly new to access. Below is the link for the database(I AM ATTACHING THE FILE AS A ZIP FILE AND I CHANGED THE EXT: TO JPEG. PLEASE CHANGE IT TO ZIP) i am specifing my problem and if you can solve the issue that would be great.
In the database, there are 3 tables :-
Categories,Experts and Region.ExpertManagementDatabase_Updated_dropdown.zip
I created 3 queries by which i am able to select the options in the form and on the click event of each level i did re-query to get the values in the list (If you will check the database once you will get the whole idea). Now once the options are selected i want to save these values in a fourth table and i think that will be a join table but i am not able to figure out how to save the values and i need to create a search page also where user can select from existing users using the search criteria which will be dependent on the drop downs that are in the table and random words.
Is there any way that i can and a multifield drop box by which i can select the options in the first drop down and once i select those i can get a second option where i can select multiple options corresponding to that one.
Please help me with this, i am really stuck with this and want to solve the issue asap.