Results 1 to 3 of 3
  1. #1
    Join Date
    Jan 2003
    Posts
    2

    Unanswered: portal filtering I think

    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

  2. #2
    Join Date
    Jan 2003
    Posts
    4

    Re: portal filtering I think

    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

  3. #3
    Join Date
    Jan 2003
    Posts
    2

    Re: portal filtering I think

    Thanks Luke

    Ill give it a try

    Ron

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •