3 Replies Latest reply on May 10, 2012 9:58 AM by Stephen Huston

    How to with my portal?

    ecpro

      Hi,

       

      I have to tabels one with persons

       

      fields

       

      person Id

       

      Person name

       

      Date (global field)

       

       

      And an other on called appointments

       

      with fields

       

      Pers Id

      Appointment date

       

       

      Now I would like a portal in that shows me the records of the appointments bases on the date.

       

      I mannage to get the recods but the problem is the name how do I make the relation based on the date and based on the pers ID

       

       

      thank you

       

      Randy

        • 1. Re: How to with my portal?
          Stephen Huston

          You only need to match on the person_ID in each table to create a valid link between the persons and their apointments.

           

          What are you trying to accomplish with the global Date field?

          • 2. Re: How to with my portal?
            ecpro

            Sorry I made the relation with person ID but I would like to see the data per date i mean I also like to make a link with the gobal date and the apointment date so I can see all the apointments for that specific date every thing shows but not the names

            • 3. Re: How to with my portal?
              Stephen Huston

              Using the global date to FILTER the portal should accomplish what you need, without using it as part of the realtionship key fields.

               

              Portal filtering is handled in the portal setup dialog. You can use a clac to make child records visible IF the appointment date is >= the global date OR IF isEmpty ( global_date ). Then you can use it at will.