Hi!
I have a table wich references to several subtables by ID-Numbers (i.e. it consists like the following: ID Name Street City Status - the fields Name, City and Status go into three different tables to avoid redundancy, they display the field value but are accessed by their own ID's - i.e. City-ref# 25 equals New York, #26 equals Chicago, and so on...)
I now have a form where all information is displayed in a more readable manner as in the tables.
How do I now code a search button to look after a search-phrase in EVERY field (also in the fields of the subtables)
and to display the record(s) matching the search phrase in the form?
Thanks for help!!!
Basey
I have a table wich references to several subtables by ID-Numbers (i.e. it consists like the following: ID Name Street City Status - the fields Name, City and Status go into three different tables to avoid redundancy, they display the field value but are accessed by their own ID's - i.e. City-ref# 25 equals New York, #26 equals Chicago, and so on...)
I now have a form where all information is displayed in a more readable manner as in the tables.
How do I now code a search button to look after a search-phrase in EVERY field (also in the fields of the subtables)
and to display the record(s) matching the search phrase in the form?
Thanks for help!!!
Basey
