Design - Responses

Posted on 2003-02-24
Medium Priority
Last Modified: 2013-12-18
I have a database with a Job main form and a EmployeeDuties response form. We create a Job form for each job and then create EmployeeDuties as responses for each employee working on the job.

I can happily create a view which lists the jobs and the employees working on them, and their duties. What I now need to do is the reverse. I need a view of all EmployeeDuties forms (first column employee, categorised) with the Job's they have worked on listed for each. So I would have the EmployeeName field categorised, several fields from the Job doc, some of which will be categorised, followed by the DutiesDescription from the EmpDuties form.

1/ Is this possible if I have the given form structure?

2/ In the past when I've needed this funcionality, I've made both forms Docs (not responses), and then built the views. It works but is complex. So, os there a better way to get this result?

Question by:gbentley
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 3
  • 2
LVL 13

Accepted Solution

CRAK earned 400 total points
ID: 8014852
1st you need to DEselect the view's option "Show responsedocument in hierarchy".

With 1 Job having multiple duties, I assume you want the job shown under each of the duties. It'll be hard to show the job a number of times, depending on the number of duties. The only way to do that is to update the job document after processing a duty: store the names of each of the job's duties on the job. Show them in the view with the option "Show multiple values as separate entries" selected.

Now you have to group and sort the right documents. Create a hidden (1st) column for that, showing the duty (for both the job and the duty!) and concatenate a "1" for a duty or a "2" for a job. Sort that column.

Disadvantage: you cannot expand/collaps the view.

Author Comment

ID: 8031473

I've gone back to doing all the updating in script and not trying to use the Response system. There goes another days work!
LVL 13

Expert Comment

ID: 8031853
Try to see that as a positive thing....
Too many people in IT go unemployed lately!

Author Comment

ID: 8031889
It's part of the game!

Remember - "Plan on throwing the first draft away"
LVL 13

Expert Comment

ID: 8031943
I remember on one assignment all people could talk about was RAD and DSDM. So we started: time-boxing, prototyping, reviewing, improving etc.
Generally the 1st prototype got slammed and battered long enough to meet ALL requirements. Even when we adviced half-way to start over again and leave the trach of patching.
Then... one day they invented something "new".... the DISPOSABLE PROTOTYPE!

Featured Post

Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Problem "Can you help me recover my changes?  I double-clicked the attachment, made changes, and then hit Save before closing it.  But when I try to re-open it, my changes are missing!"    Solution This solution opens the Outlook Secure Temp Fold…
IBM Notes offer Encryption feature using which the user can secure its NSF emails or entire database easily. In this section we will discuss about the process to Encrypt Incoming and Outgoing Mails in depth.
In this brief tutorial Pawel from AdRem Software explains how you can quickly find out which services are running on your network, or what are the IP addresses of servers responsible for each service. Software used is freeware NetCrunch Tools (https…
This is my first video review of Microsoft Bookings, I will be doing a part two with a bit more information, but wanted to get this out to you folks.
Suggested Courses

777 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question