if you look at the nouns in your description it strongly suggests two tables.. people/person/competitor and rounds
Hi, Jon. It would help if we knew the fields in your table(s), the relationship(s) that exist, and the predicates used in those relationships.
I know this isn't the 'here's the solution' response you want, but to be successful in database development, you need to start with an ERD - a diagram of your database tables...first. FMP does not have this capability so you need a separate tool.
Having a clear understanding of the database before "jumping in" can save you hours, days, weeks, and even an application that has lots of code all over the place to try to "fix" the database design (which it never really does and only is constant frustration).
I use SQL Editor. Once you create your database, it will even CREATE YOUR FILEMAKER DATABASE FOR YOU FROM THE DIAGRAM!
Then, when you post your diagram, people here can understand what your design is and offer more targeted help.
HOPE THIS HELPS.
That does sound like a good idea,
This is a one off for a friend, I thought I could make it with no problem, oh how so wrong I was
but next time I'll take your advice, Thanks
what "SQL Editor" are you referring to?
Thanks for your reply.
The tables are as follows:
Table 1 Table 2
Comp ID --------------------------------- Comp ID
Club name Card 1 (they have two scoring cards for 1 round)
Name Card 2
Round (There are 10 rounds which are on a drop down field)
There are multiple names in Table 1 and they all have 10 rounds each.
I hope this is clearer,
Thanks in advance,
Yup, no such thing as a "quick system". We've all been down that road...
Relationships are complicated things aren't they . I would suggest that if you want to see a different record for each round then use a portal to have multiple Table2 records for that Table 1 CompID, you can filter the portal by "Round" if you want. An example file would help if you want to post a file.