Ive written a database that keeps track of all the TV shows we are editing and mixing. Each Record is the TV show in house and the editor assigned to cut each reel of Dialog and Effects.

Here is an example:

Show JAG 121

Act1 DIA Dave

Act1 EFX Mike

Act2 DIA Joe

Act2 EFX Mike

Act3 DIA Dave

Act3 EFX Steve

Act4 DIA Sue

Act4 EFX Steve

I want to be able to search by editor to see how many Acts they are assigned each week. How can I set up a relationship so if I search Steve it would display:

Jag 121 Act3 EFX

Jag 121 Act4 EFX

These fields were set up as repeating fields, but I would change them to make searching easier.

Thank you

Kevin

Instead of using repeating fields, you should use a separate database... I'll call it "line items", to which you can enter data through a portal in the shows database.

That way you can search the line items database for a particular person, then relate back to the shows database (through related fields) to get the show information.

The added benefit will be that you can then have an unlimited number of people assigned to a show, whereas you previously had to have enough repetitions of the field.

Thank You Jason!!!!!

You Guided Me In The Right Direction

Kevin