How do I search for a particular record across 6 input forms

[JOHN AT ST HELENS]

I am creating a database for our clerk and wish to make finding a particular
record easy. There will be about 250 records spread across 6 forms which have
different layouts and different types of data in them. There is one defining
field called Indicatornumber (unique value) which is common to all 6 forms .
Each form has its own table. No forms are linked as yet. I want the clerk to
be able to find the record containing the indicatornumber she wants without
going into each form and running a separate search. Once the record has been
found she will update entries on the form. I know that I can create a list
and use macros to turn to the relevant form but I want to make it easier than
this. how can it be done - I am a frustrated ex Approach user - this would
be easy in Approach - but I have to use Access !!! Many thanks.

 

[Steve Schapel]

John,

I think you need a table, with at the very least an Indicatornumber
field for all records, and another field that indicates Type (i.e. which
of the 6 categories each record relates to).

If there are other fields in common between the 6 groupings, these also
should probably be in the Master table, rather than in the separate
sub-classing tables as well. If you would care to give some more
details about the data you are working with here, with examples, someone
will be able to advise more explicitly on this aspect.