Hi,
How does one filter using multiple fields on a form?
If I have a pet database that has the following fields
petid
type
name
On a form I wish to select a pet type from a drop down box that shows a list of unique types of pets in the database (cat, dog, elephant).
If I select cat then in the next field I would like to select the cat's name from a drop down.
Then I would like to save the pet id for this selected pet in petid.
I guess it is a combination of combo box and save value for later use and then perform an updated query?
If it is this can you describe how you perform this updated query please?
Regards,
David.