# 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

111     Toms Paint         \$2500       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