So I have numerous tables all related via a unique ID, and in a form I want to be able to search for certain sections of tables.
I am not sure if this is actually possible, but;
For example;
If I type "Pilot" into the textbox, I want it to search and show every table 'Field' with the word Pilot in the title.
and if I typed "Engineer" do the same, however finding every field with the word Engineer in it's title.
Any ideas would be appreciated. I have searched long and hard for tutorials or other examples, but haven't found anything too helpful.
Thanks in advance.