b_c
12-04-2009, 07:04 PM
Hello...
...is there a way to take "any" field in a form and make it the criteria for a query find/return?
I am building a database to record patient records. I have the normal fields you'd think you'd find like FirstName, LastName, CellNumber, InsuranceNum, etc in the PatientTable...
...i'd like to build a query that would allow me to use a form w/ all these fields, and search/return information based on what i fill into any of the cells...
...say for instance if the client doesn't have their InsuranceNum, i'd like to be able to type in their last name, and be able to pull up their information.
possible problems or complications i see w/ this is what if i have multiple patients in the database w/ the same last name.
i hope you get the gist of what i'm trying to do...do you think you can help?
should this question be in the "forms" folder?
cheers,
b_c
...is there a way to take "any" field in a form and make it the criteria for a query find/return?
I am building a database to record patient records. I have the normal fields you'd think you'd find like FirstName, LastName, CellNumber, InsuranceNum, etc in the PatientTable...
...i'd like to build a query that would allow me to use a form w/ all these fields, and search/return information based on what i fill into any of the cells...
...say for instance if the client doesn't have their InsuranceNum, i'd like to be able to type in their last name, and be able to pull up their information.
possible problems or complications i see w/ this is what if i have multiple patients in the database w/ the same last name.
i hope you get the gist of what i'm trying to do...do you think you can help?
should this question be in the "forms" folder?
cheers,
b_c