Links and Relationships Help !

[wrkadri]

Hi all,


I work with an NGO and developing an access database.
I am working on a database that has the following tables:
(Personal Information, House Information, Livelihood and Social Information, Shelter Information, Water Information, Sanitation and Hygiene Information, Other Needs, PUAMI Projects, PUAMI Activities). I have managed to link all above tables in 1 to 1 relationships as each beneficiary (Personal Information) can hold one and only one information from other tables. What I want is the following:
I want to work on these tables:

Projects:

ProjectID	AutoNumber
ProjectCode	Text
ProjectTitle	Text
ProjectDonor	Text
ProjectStartDate	Date/Time
ProjectEndDate	Date/Time
ProjectStatus	Text

Activities:

ActivityID	AutoNumber
ProjectID	Number
ActivityCode	Text
ActivityName	Text
ActivityBaseOfOperation	Text

The above two tables are linked with one to many relationships where one project can have many activities. (Note: same project can have the same activities but with different ActivityBaseOfOperation)

Check Relationship Image:


Check Form Image:


What I want to do is to link certain items to activities where each item is linked to a certain activity in the activity table based on the ProjectCode and ActivityBaseOfOperation.
(Note: each activity can have many items).
For example table Sealing Off:

SOID	AutoNumber
NumberOfSO	Number
SODistributionDate	Date/Time

I want to link this table to Activities and have a link from this item to a certain activity according to ActivityBaseOfOperation (South, North).

I will show you the activities that I have and then you can have a clear idea of what I'm asking for. Check Image Below:

As you can see I can have RE linked to ProjectID 3 but with different ActivityBaseOfOperation.

Thank you in advance.

[orange]

There is a tutorial at this site that will lead you from business facts to tables, normalization and a data model of tables and relationships to support your business. Work through the sample, then use the procedure to set up your database.
http://www.rogersaccesslibrary.com/T...lationship.zip

good luck

[wrkadri]

Thank you for the relationship tutorial but what I need is to link each record in SO table into another one in Activities. For example one person can benefit from many sealing off distributions in which each distribution is linked to a certain activity. I don't want to add a new activity whenever I have a single distribution.

[orange]

You are talking "jargon" to most of the readers. If you really want assistance, then I suggest you help the reader understand your situation. What exactly are your business rules/facts? What do the terms mean in "plain English"?

I don't think I have ever met a "sealing off distribution". How would I describe such a thing to someone just learning Access?

If you didn't really care for the tutorial; or didn't understand it, then do it again using your own data.

but what I need is to link each record in SO table into another one in Activities.

- I think you may have misunderstood the tutorial.

Whatever next step you choose to follow, just remember that your underlying database structure - tables and relationships - is the foundation of your database application. The better the foundation matches your business facts, the longer lived and less maintenance and surprises (work arounds) as you proceed.

Good luck with your project.