Multiple subject searches in access '00

  • Thread starter Thread starter Eddie
  • Start date Start date
E

Eddie

Hey,

Ive built a database that tracks my dealers, and all
service, product returns, and product orders associated
with them. Works fine when the dealer only has one name.
My problem is that a big dealer of mine has 3 names. I
cant get him to decide on a name for his business, so I
need to work around it with my system.

Is there any way for me to associate my dealer with his
other names so that a search for example "Bills Electric"
would also bring up "Bills Microwaves," "Bills
Televisions," etc without creating a new database for each?

email me if you have a solution.

much obliged.

-EA
 
Hey,

Ive built a database that tracks my dealers, and all
service, product returns, and product orders associated
with them. Works fine when the dealer only has one name.
My problem is that a big dealer of mine has 3 names. I
cant get him to decide on a name for his business, so I
need to work around it with my system.

Is there any way for me to associate my dealer with his
other names so that a search for example "Bills Electric"
would also bring up "Bills Microwaves," "Bills
Televisions," etc without creating a new database for each?
Click to expand...

It sounds like you have a one-to-many relationship between Dealers and
DealerNames. Perhaps you should have two tables: Dealers, with the
basic information about all your dealers, and perhaps a "preferred
name"; and DealerAliases, with a foreign key linked to the primary key
field of Dealers and a field for alternative names.

Certainly creating a new Database (.mdb file containing multiple
tables, forms, reports etc.), or even a new Table (which may be what
you meant) for each dealer is a non-starter!
email me if you have a solution.
Click to expand...

Done... but please be aware that this request is considered impolite.
The volunteers like me who donate time to answer questions here prefer
to keep discussions in the newsgroup; private EMail support is for
paying clients.
 
Back
Top