The date in your activity fields should be entered into a related table instead of a series of fields like this. You can use portals to orgainize the data into columns on your first example and base a summary report on the portal's table to get the second example.
Staff::StaffID = Activities::StaffID
To get columns of data like your first example, you can put two portals side by side with the activity name and notes field inside the portals. Set the first portal to display 1 row starting on row 1 and the second to display 1 row, starting on row 2. You can use a third field in this table to set the preference and then sort your portals on this preference field if you want.
Your second layout can place the activity name field in a sub summary part when sorted by activity name and you can place the Staff Name and Activity Notes fields in the body to get a report grouped like you show--provided you sort your records by activity name.
So a new table is to be created with the following attributes:
Fields: StaffID, Activity1a, Activity1b, Activity2a, Activity2b, Activity3, Activity1aNotes, Activity1bNotes, Activity2aNotes, Activity2bNotes, Activity3Notes
Fields: StaffID, ActivityName, ActivityNotes
Am I understanding correctly? Forgive me as I have been up most of the night....
HA! Yea, I wish. Deadlines=NoFun/Stress
I will try this new setup...thank you for your input. Fresh mind, new ideas. I may have more questions, but this is a good start.
Okay setup...but now I have one (probably the stupidest) question...
How am I able to add more than one activity to each staff member? as well as notes?
You can add that data directly to the portals or you can use a layout based on the portal table.
If you use the portal, enable "Allow creation of records via this relationship" for the portal's table in the relationship you set up for the portals.
If you use a layout based on the Activities table, you can format the StaffID field in this table to be a drop down list or pop up menu of StaffID's (column 1) and names ( Column 2) so that you can create an activity record, then select the appropriate staff record to which it should be linked by selecting that person from the drop down listor pop up menu.
Yes sir!! That was it. Why did I want to make it harder than it needed to be??? Thank you very much PhilModJunk!!