AnsweredAssumed Answered

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

Question asked by Thicks on Feb 18, 2011
Latest reply on Feb 18, 2011 by philmodjunk

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

Outcomes