1 Reply Latest reply on Feb 18, 2011 11:08 AM by philmodjunk

    Can I do this with a portal or would I need to use a repeating field?

    Thicks

      Title

      Can I do this with a portal or would I need to use a repeating field?

      Post

      My thoughts are that I can use a portal to a related table through a jointable but you let me know.

      Here is what I am trying to accomplish

      Okay the portal is easy enough it would pull over companies info

      firm#  Business Name     Amount   UDBE/DBE

      111     Toms Paint         $2500       Udbe

      123     Dads Rolling       $1000       Udbe

      654     Sam Const         $3000       Udbe

      I have a goal amount for the contract of $5000 and I need to know how many companies it took to reach the goal. Howerver I need to know the maximum amout of companies that it could be. So to do this I would list the companies from lowest to highest and count how many it took to get to the goal.

      $1000 + $2500 = $3500 + $3000 = $6500

      finaly hit my $5000 goal with the 3rd company so my answer would be 3

      Can this be done with a portal or will I have to use repeating fields....

      Thanks I'm confused