what I would like to do is not have one students as shown below, but be able to add the next 7 competitors and their results.
I believe you need to use a portal to the table that lists the participants of the event. It's hard to be more specific with only a screenshot to go by.
Thanks for the lead Michael, I will look it up!
Sounds like you have two tables right now, Students and Swimming Carnival (data base). I agree with michael a Portal would view the students to the carnival event (one table) I would create another table with a relationship to the student. to enter Events swam and fields for results, could use Value List to control Different events from a reference table...
Hope this helps, 3 or maybe 4 tables. One to Many Swimming Carnival (this year) Student (many) - Events (many). I have created an IEP program with about 60 tables... It can get a bit crazy...
Keep me in the loop.
In-house Developer FileMaker Pro 11 for Citrus County Schools, Florida