Using search field to find matching data

[rthakral]

Hi, good morning!

Let me start with an example of what I am trying to accomplish:

I have 5 tables, each table has a form/screen attached to it where we input the data to get it to show up within the table.

5 tables are:

Branch
Denovo
Consolidation


Relocation
Committee

I need to use the RSN # to pull up a certain record in the committee table. So i type in 25 in the search field at the bottom of the screen (the one that comes with the database) Upon typing 25, the specific record populates on the committee form.

The same record 25 has two or three other portions within it which are populated within the denovo and branch tables/forms.

Now here is my question: Is there a way to, upon typing '25' in the search bar at the bottom that it lets me tab through all records with the number 25 in them not just in the committee table but within the whole database? Like, if there's a 25 within commitee, it should show that but also let me tab through to find number 25 in denovo as well as number 25 in branch?

Can someone please advise? Any help would be greatly appreciated, thank you!!

p.s. not familiar with coding or anything so i wouldn't know where to begin with that. Very simple DB builder. Thanks!!

[JeroenMioch]

I dont think you can
I guess you can make it happen if you make a custom searchfield, but even then you would run in to certain kinds of problems.

Your form is basicly based upon one single table. And allthough you can display data from other tables on your form using dlookup function for example it is a lot of hassle for a novice.

Someone correct me if im wrong please

[JeroenMioch]

Btw as im thinking in solutions rather then problems. I can advice or help you accomplish this though but unless you post your database (with some fake data btw) it will be hard to guide you through the process.