| | |
|
|
|
Multiple subject searches in access '00 |
|---|
| message from Eddie on 3 Jun 2004 |
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
|
| John Vinson replied to Eddie on 04 Jun 2004 |
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!
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.
John W. Vinson[MVP]
Come for live chats every Tuesday and Thursday
http://go.compuserve.com/msdevapps?loc=us&access=public
|
|
Archived message: Multiple subject searches in access '00 (MS Access Error Message)
