Multipule distinct lookups in one table

[Tom11]

Hello again smart people of the FMForum,

Here is my problem:

I have an attendance table with 25 first name and 25 last name fields on it. I Would like FMP10 to automatically look up each person when they are typed in and then find them in the Member Profile table and list their status (If it helps it is a single yes or no status). The problem is that I can not figure out how to do this for each name individually.

I got so frustrated I am rebuilding the attendance table from scratch, so any help is appreciated. For a basic idea it looks/will look something like this:

Date ____

Group ____

First Name ____ Last Name____ Crime Victim____

First Name ____ Last Name____ Crime Victim____

First Name ____ Last Name____ Crime Victim____

First Name ____ Last Name____ Crime Victim____

First Name ____ Last Name____ Crime Victim____

and so on, each person being different (but all should be in my member profile table)

Currently I can get it to lookup based on the name, but it then uses the name for all the crime victim slots and not just the one next to it.

Unfortunately I am the accidental techie at a non profit that needs this done soon for a grant. Thank you in advance, unknown person who helps me :(

[Vaughan]

"Here is my problem: I have an attendance table with 25 first name and 25 last name fields on it."

Yes, that is the problem. There should be a related table with 1 first name and 1 last name field, and there should be 25 records related to the attendance record.

Display the related records in a portal.

[Tom11]

Thank you Vaughan, I knew there would be a better way to do it. I will see if I can figure out how to implement that (much better) way. I would like to have a list in each member's profile of all there attendance listed from when it is entered into attendance, I am not sure how yet, but your way will help me get there (I think).

Sorry it took so long to respond, we are still in crunch time on the grants.