I was recently hired to start a Child Advocacy Center for a county in Washington. The budget is small, and I need a way to collect and store some data related to each child client we serve. I have limited experience with Access and am trying to build a database.
One of the things I need to collect and relate are Child Client Name, DOB, demographic information as well as Suspect Name, DOB, demographic information. I need the Database to be able to reference three suspects per client for those rare occassions where there is more than one suspect.
Here's a part of what I have done.
names table containing fields for nameid, first, last, dob, gender, race, ethnicity, etc.
mdt table containing fields for clientid (nameid), suspect1id (nameid), suspect2id (nameid), suspect3id (nameid) As weird as it seems some clients may grow up to be suspects so each person would have their individual name record that could be related to multiple mdt table records.
I have tried a many to many relationship between the names table and the mdt table, but am not able to query the names table and mdt table and return any records. I'm stuck and looking for some assistance. I would be more than happy to zip and email the database to someone willing to help.
Thank you,
Dave Helvey
Posted by: dhelvey@gmail.com
| Reply via web post | • | Reply to sender | • | Reply to group | • | Start a New Topic | • | Messages in this topic (1) |
Tidak ada komentar:
Posting Komentar