D
deekaye
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
| Contact4 | Contact5 |
Activity1 | |
Activity2 | Activity1 | Activity1
Activity3 | Activity2 |
Activity4 |
| Activity3
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.
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
| Contact4 | Contact5 |
Activity1 | |
Activity2 | Activity1 | Activity1
Activity3 | Activity2 |
Activity4 |
| Activity3
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.