Showing multiple interactions for multiple contacts from a single company

[deekay]

I am trying to create a form that will show all the interactions with
all contacts for a particular company.

The database structure is like the following:
A company table that stores company specific information
A contacts table with all contacts details
An activities table with all recorded interactions with specific
contacts.

And they are related like 1 company to many contacts and 1 contact
with many activities.

Each activity logged has a specific log date, activity description,
user that logged etc.

At a single glance I would like a form that would show the people with
whom we have had the last few activities with at a company.

Something like:

Company
Contact1 | Contact2 | Contact3
Activity1 | |
Activity2 | Activity1 | Activity1
Activity3 | Activity2 |
Activity4 |


Where:
- Contact1 had the latest activity, contact2 the next latest etc...
- Also Activity1 to Activity5 under Contact1 is such that Activity1 is
the newest, Activity4 is the oldest.
-Every Activity in the same row occurs on the same date so Activity2
for Contact1 and Activity1 for Contact2 both occurred on the same 'log
date' but there was only Activity1 for Contact1 on that date (so there
should be nothing/blankrow under all the other contacts).

Does anyone have any idea how I could create this interface, please
your help would be really appreciated with as much detail as possible.

 

[Albert D. Kallal]

I would think you have a main form with the company details.

then, on the left side (low left quad), you have a continues form that lists
all of the
employees. As you navigate up/down through each employees, on the right side
(lower right quad), you have
a another sub-form that lists the activity for each employee.

if you look at the LAST screen shot in the following, you can see such a
form.

(this form is for entering donations..but, note how the top part is a
particular batch job (would be company in your case), and then
note how the left grid is employees..and the right side is details for that
particular employe (in the example, it is dontations details..but, it could
just well been favorate colors, hobbies...or actives in your case).

http://www.members.shaw.ca/AlbertKallal/Articles/Grid.htm

So, the above might give you some ideas...the general approach to display
"many" records in a relatonal format is to use grids as those screen shots
show...