To all,
I have been working with an extremely long database and would like to do a specific search which I haven't been able to figure out. It would be better if the user was able to search this database with two combo boxes. On the first one the user would select what field he is interested in searching. The second box would automatically load pre-assigned values that are common to a number of fields. (In Netscape there would have to be a submit button since this automated response doesn't seem to work with netscape) After selecting the subfield on the second box and clicking the search button all of those records which are common to the first and the second box would then list.
I have figured out how to design two combo boxes which automatically updates, but I do not know how to make them read only one table. All literature on this shows a different boxes for each table available. Does anyone know how to do this with one table!
I greatly appreciate everyone's help!
Daniel
I have been working with an extremely long database and would like to do a specific search which I haven't been able to figure out. It would be better if the user was able to search this database with two combo boxes. On the first one the user would select what field he is interested in searching. The second box would automatically load pre-assigned values that are common to a number of fields. (In Netscape there would have to be a submit button since this automated response doesn't seem to work with netscape) After selecting the subfield on the second box and clicking the search button all of those records which are common to the first and the second box would then list.
I have figured out how to design two combo boxes which automatically updates, but I do not know how to make them read only one table. All literature on this shows a different boxes for each table available. Does anyone know how to do this with one table!
I greatly appreciate everyone's help!
Daniel