Filtered Relationship?????

[ZzingG]

Hopefully I am posting this question in the correct forum. Not sure if this is a relationship or portal problem.

I am trying to filter a relationship so that it only shows a employee working at a site once even if they work there each day of the week. I have the following structure:

clients-----workday

clients-----schedule

schedule ---employee

The report prints from the clients file. There is a relationship into workday to get the list of days that need worked. There is then a relationship into schedule to get the list of employees that are working that client. The problem is that if a employee works a site each day of the week it shows their name 5 times not just once. I need to some how filter it so that each employee working a client only shows once.

I am running up against a wall here about how to get around this. Any ideas or thoughts would be great. Thanks in advance.

[Ugo DI LUCA]

one solution here

[ZzingG]

I gave the above link a try. I was able to get it working, not sure I fully understood what was going on but it did work. Only problem was all the blanks that where at the bottom of the list. There are some clients that have 5 or 10 people working each night of the week. That is a list of ~20 or more blank records. As I am printing a list of all clients(over 100) there is going to be some that have a lot of wasted paper printing a list of blanks.

I was wondering about the following,

I have a script that sets the employee to work a certain schedule. As the script creates the record in the schedule database it could also add a client_id to a field in the employee record that is a array of all the clients that employee works for. Then use that field on the right side of a relationship to pull a employee name once for each company they work for. One thing I am having a problem with is how to remove of a client_id from that array field once that employee no longer works a client, without destroying the rest of the data there. Not sure how to read the field for a client_id and then get just that data deleted. I am going to go poke around the script section for more help as I don't think this is a relationship problem any more.

Thanks for the help,

Philip

[Fitch]

"...how to remove of a client_id from that array field..."

Substitute (array field, client_id & "

[Ugo DI LUCA]

Hi,

Well, not sure which method you used. The Max method wouldn't work in your case as it applies upon all the records from the related file, while you're looking at a filtered list from some keys from the left side.

This method was given as an example that you should adapt to your case. I'm quite sure you'll end by a script here that would mark all records with a 1.

Then your script for prints should only find the record with a 1, therefore, no blanks record would appear.

Tell if you need more help here.