Re: Search Across unrelated forms.

It is very unusual that you would want to do the same search across
multiple tables, in a properly designed relational database. I think
you may have designed your tables to match the forms! This is generally
not correct. The tables should be designed to reflect the logical
structure of the information, regardless of how that information is
eventually displayed on the forms & reports.

Tell us the following details for each table:

- the table name;
- the names (not types & lengths) of the fields;
- which field(s) are the primary key for that table.

Then we could comment on the table structure (if you'd like us to do
that).

HTH,
TC

.

Relevant Pages

  • Re: many to many problem
    ... DivisionID completes the compound primary key and acts as ... a single division of a single company -or- multiple divisions of a single ... > l beginning with Starting Out and Database Design 101. ... tblLinkCompanyContacts is a ManyToMany linking table Can I create ...
    (microsoft.public.access.tablesdbdesign)
  • Re: many to many problem: John Vinson and Lynn Trapp - help?
    ... DivisionID completes the compound primary key and acts as ... > a single division of a single company -or- multiple divisions of a single ... >> l beginning with Starting Out and Database Design 101. ... > tblLinkCompanyContacts is a ManyToMany linking table Can I create ...
    (microsoft.public.access.tablesdbdesign)
  • Re: New arrivals (II)
    ... multiple; and what I need to get back is a list of items, ... primary key (i.e. unique index) on keyval.id ... INSERT INTO item(id, colour, weight) ...
    (uk.rec.sheds)
  • Re: DDL Created but how to get key constraints and primary key etc
    ... If Claims_id is the primary key in the Claims table, ... cannot be multiple claim_id values in the table. ... Sample data & expected results are missing, ... (Note that this is not a complete schema and many other constraints ...
    (microsoft.public.sqlserver.programming)
  • RE: Appending question
    ... have a primary key that consist of multiple fields.>>> ... Private Sub Command4_Click ... Dim stDocName As String ...
    (microsoft.public.access.queries)