A better question

[gtag]

I'm trying to make sense portals and seem to be missing some key instruction. I have the attached database built and what I would like to do is use the EVENT_ID to display a list of competitors who have finished in the top 16 places for events that had similar conditions. I admittedly have no idea how to do this, so I thought an easier step would be to make a portal that displays the events that match the conditions criteria. I have used a few samples from this forum, but alas, I have no idea why they work, or don't work. All I need is a little push in the right direction to keep me learning. Thanks!

EDIT

Maybe someone can just tell me how to make the policyID in the "Filter_Portal"(attached below) a non-variable for the portal? I changed the values so that the 30 records in Policy are between 1 and 10 instead of just two. I would like to see ALL records being filtered instead of just one PolicyID at a time. I can't figure out why it works that way

SURF_TUTORIAL.fp7.zip

Filter_Portal.fp7.zip

[Søren Dyhr]

Here is how I think it should go? Part of your problem is that your data is inadequately normalized, not that I've gone all the way in that direction either, but I have removed duplicate entities ... but might have misplaced them slightly. But as such could it look like Event's should be broken further out in tables?

--sd

SURF_TUT_mod.zip

[gtag]

great. thank you a ton for taking some time to help me. One question on this mod; Does the global field you used in the SURFERS layout that allows me to pull up each record have anything to do with the other TOC's you put together (the one that connects surfers based on wave size)? Is there any kind of dependency there that I don't yet see?

Thanks again. I know how elementary, and probably even wrong, my database is but I'm just cutting my teeth here on something fun while I figure out the foundation of FMP. So thanks a ton for taking some time to help a rookie out.

[Søren Dyhr]

have anything to do with the other TOC's you put together (the one that connects surfers based on wave size)? Is there any kind of dependency there that I don't yet see?

Well I'm not quite aware of what you are able to see or not - But yes it's the same set of tables behind each occurence if that's what you mean. The RG is not an entity relation diagram!

So each group belongs to one particular layout, eventhough it uses the same set of tables. Read up upon TO, TOG and table!

--sd