M
Mike Webb
Hello all,
I am using Access 2002 and do not know VB or SQL.
I started with 2 tables: Contacts (i.e., name, address, etc.) and
Organizations (those the contacts are sorted into for (we hope) retrieval by
common groups). I have ~2K contacts and ~90 organizations. I created a
table I called Join matching the ID # of the Contact with the ID # or #'s of
the Organizations they are assigned to. I now have a subform for each table
listing these ID numbers for the other table that match up. I want to
create a means to search the Join table, or the other 2 (it's been a
frustrating day of experimentation before I decided to ask this newsgroup)
so I can see a form or table with the Contact info and the Organization Name
(I have that in a column called Description in table Organizations) together
so the staff here can read it in plain English?
I've tried creating forms and queries with and without the built-in wizards,
and also tried "findrecord2k.mdb" from www.mvps.org/access to see if I could
use it to build a query - but I got lost.
Can someone give me a "push" in the right direction?
TIA,
Mike
I am using Access 2002 and do not know VB or SQL.
I started with 2 tables: Contacts (i.e., name, address, etc.) and
Organizations (those the contacts are sorted into for (we hope) retrieval by
common groups). I have ~2K contacts and ~90 organizations. I created a
table I called Join matching the ID # of the Contact with the ID # or #'s of
the Organizations they are assigned to. I now have a subform for each table
listing these ID numbers for the other table that match up. I want to
create a means to search the Join table, or the other 2 (it's been a
frustrating day of experimentation before I decided to ask this newsgroup)
so I can see a form or table with the Contact info and the Organization Name
(I have that in a column called Description in table Organizations) together
so the staff here can read it in plain English?
I've tried creating forms and queries with and without the built-in wizards,
and also tried "findrecord2k.mdb" from www.mvps.org/access to see if I could
use it to build a query - but I got lost.
Can someone give me a "push" in the right direction?
TIA,
Mike