T
tandre
Guest
I m working in this health database which is actually my first serious one. I would like the user to be able to select from two combo boxes in a form the appropriate table and field that suits his needs [the combo boxes must be filled with the names of the tables of my db, and the fields that are included in the selected table] and then be able to filter the produced query choosing : bigger or smaller than a given value . For example :Which records from the field glucose_level of the table tblLaboratoryExams have a value bigger than 200 .I need only one field from each chosen table. In short , I need through user input to be able to build a one field [from one table] querry. I know i could do this for each field separately but there many fields , and this would increase my db size very much . Has any of you guys encountered smth similar? Please give some general directions or a url I could get information from.
