Originally posted by ronnieb
I have 2 files one called main and the other called test in the main file I have 5 fields

1. This is a (text field) will either be Job or Quote
2. Done (text field) will be either Yes or No
3. Scheduled (date field)
4. Type (text field) will be pickup, delivery or other
5. ScheduledTest (calculation field) if This is a=”Job” and Done=”No”,Scheduled,””)

In the test file I have a bunch of portals that are populated with the jobs that the scheduled date matches.

Every thing works fine however I would like to be able to find a way to show just the pickup jobs, delivery jobs or all the jobs in these portals.

For the life of me I can’t seam to get it to work.

any iders
Thanks

Based off what you have told us above, you should create a multi-line key.
Key (Calculation) =
FieldA (Job or Quote) & "(Back to Front P - New Line)" &
FieldA (Job or Quote) & "-" & Type (Pickup, Delivery, etc.)

Create a relationship between the two files, with a SearchField in Test which = "Job", "Quote", "Job-Pickup", "Job-Delivery", etc.

This will allow you to filter the matching records, via a portal (with the same relationship) to show the records you are looking for.

Luke