N
NC Girl
I am having a hard time trying to create a search on two fields on the same
table. I have one table that is linked to three other tables. What I want
to do is to have the primary table with two fields, i.e. name and id number.
Have the user be able to do a search on either one (not both) and bring up
the other records that is linked to the primary record. The filtering does
not work for more than one field and I know I will need to do some
programming but not sure where to begin and how to finally get the end
result. Thanks for your help.
table. I have one table that is linked to three other tables. What I want
to do is to have the primary table with two fields, i.e. name and id number.
Have the user be able to do a search on either one (not both) and bring up
the other records that is linked to the primary record. The filtering does
not work for more than one field and I know I will need to do some
programming but not sure where to begin and how to finally get the end
result. Thanks for your help.