I'm creating a db in Filemaker 7 for me to track musicians who will be performing in a worship service for church. I am working with 2 tables, (1) Music Schedule and (2) Music Schedule line item. I am trying to create a portal in the Music Schedule db to view the following in columns.

Service Date Prelude Offertory

1/1/204 John Doe Mike Jones

I really would like the prelude and offertory to be the same field from the Music Schedule line item table so when doing searches, I can do so in 1 field. How do I view the same field under 2 columns and yet tie it to 2 different categories without having it display in 2 portal rows with the same date?

Thanks for your help!

Sam

Here's a sample DB I threw together to do what you want. It's hard to explain it (it's late) but look at the relationships and the two portals. The left shows what you want, and the right shows all the individual records. Let me know if you have any questions

music.fp7.zip

Thanks so much for working up the file solution!! That makes sense!

Thanks,

Sam