Can I do this with a portal or would I need to use a repeating field?
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
Please don't use repeating fields. While not impossible, that would be really complex to set up.
You can use a running total to add up your contract amounts.
If you have FileMaker 11, you can even filter the portal so that RunningTotal < Goal filters out all records past the point where the goal is reached, if you find that useful.