The Mudcat Café TM
Thread #47406   Message #706809
Posted By: Homeless
08-May-02 - 01:58 PM
Thread Name: tech: Access 97 Database: HELP!!!!!
Subject: RE: BS: Access 97 Database: HELP!!!!!
ok, but sames fields isn't necessarily a relationship. A relationship means that a record in each table will have the same *data value* in the fields, not just the same fields. Just having a PhoneNumber in two different tables isn't going to help you. For the tables to be related, at least one record in each table would have to have the same phone number. Then you could join the records in those two tables.

I'm guessing that what you needs is an additional table that lists the reasons someone would need the resource, and which resource is applicable. So the fields it might have would be "diagnosis" and "phoneNumber". That way you could query for "Depression" and join on the phone number to your other tables.