Sam

I have created a "Student" database with the following tables... Student Groups Grouplineitem See attached picture of layout Working from the "Student" layout, I want to create a portal on the left side of the layout and have it list all the students names who are in a certain group. For example, if I want to view just the "Band" members, I would have a global field with the name of the group. Once selected, it would then view just the "Band" students. I have been able to get this relation set up. My problem is I want to click on a students name and have it go to their record in the current layout which is the "Student" layout and table. I cannot get this to work using the "Go to Related Record". I really need to keep this on the Student's layout using the student's table. Any suggestions? Thanks, Sam

Is there no way of creating a 1:1 relationship using the occasions and themes tables the Collections layout only, even though I am going with a 1:M relationship in the songs entry?

I've attached to this posting 2 jpg files that will clarify why I need a separate table for occasion and theme.

The file I posted on this forum is not the full solution fill I am creating. In my original file I have a song layout that allows me to enter individual songs and assign multipule occasions and themes through a portal. However when dealing with collections I think it is too confusing to have multiple occasions and themes. That is why I am going with 1:1 relationship on the collections layout only. I appreciate your help.

That is exactly what I want it to do, however the portal fields occasion and theme need to come from the occasion and theme tables, not the song table. That is because the other part of the solution I'm have created which is not part of this file allows for multiple occasions and themes.

The reason I'm doing this is because some of the songs in collections don't always have the same theme or occasion. In the event that a collection does have the same theme and occasion, I do not want to have to enter it into every portal field. I also will add songs into the database that are not in a collection, and so I need a table to store themes and occasions.

I tried to do a lookup and still did not have any luck.

I am creating a music cataloging database and I'm trying to copy data into a portaled field if there is data in another field. I would like to do this without a script, but I am am not having any success. I've attached the file to this post. Thanks in advance for your help! Sam Music_Collection_Test_Solution.fp7.zip

I have created a database where I catalog my print music, some individual scores and some in a collection. I have created a Layout titled "Collections" to enter songs that are in a single book. My tables are: Collection Songs Occasion Lineitem The Occasion table is to label the music for "Christmas" or some other season. My layout is based on Collections and I am entering songs through the song portal. My problem is I want to enter the occasion as I'm entering the song title and other information. When I enter the occasion, it disappears. When I click out of the portal and back in it again, I then can enter the occasion. My relationship is: Collection Table Songs Table Collections ID Collections ID Songs Table Occasions Lineitem Table Song ID Song ID What am I doing wrong? Thanks, Sam

Tom, Would you please give me more details on how I would create the relationship. What do you mean by base? Thanks

I am stuck on creating a relationship in a printed music catalog database. I would appreciate any help you can give me. This database tracks printed music. My desire is to create 1 layout and but view music titles with tab views and portals. An example is attached to this posting. I want to view the portaled music with the following tabs. Song Details By Occasion By Style By Theme Here are my tables Songs Occasion lineitem Style lineitem Theme lineitem Note that each song can have more than 1 occasion, style and theme. My questions is…can I develop this using only one layout and tabs, or am I going to have to use multiple layouts? Thanks for your help.

Thanks so much for the advice! It is working like a charm.

HTH, Thanks for the info. Question: Since I already have all the students in a table, how would I go about writing a script that would automatically assign them to the seats? Would I script a copy and paste student ID and loop it? Thanks so much for your help!

I am creating at database that will automatically assign seating in an auditorium. The layout of the auditorium is configured in sections, rows and number of seats. Each section does not have the same number of rows nor the same number of seats in each row. Question: Is there a concise way to script this? The long way is to create global fields to tell what is the maximum number of rows in each section, then one for each row to tell how many max seats. Then create a looped script to go through each section. I am assigning seats to 400 elementary students. I have a table with all their names. All kids in grade 1 need to sit in Section A. All kids in grade 2 need to sit in section B and so on. Is there a better way? Thanks for your help.

I have created a portal displaying songs from a songlineitem table. How do I go about showing only the songs of a certain style and have the ability to also show all the songs via a conditional field. I've been able to do this with a repeating field, but I want to stay away from that because of the limits to report with a repeating field.