Hi, Im building a royalty database where each album has artists, Producers, and songs, and each song has authors. It works up to there but i cant keep a unified address book of the authors, artists, and producers, I dont know how to do that. Please look at my file and make any suggestions.

Thanks

Alex Rodriguez

VastagoRoyaltiesV2.fp7.zip

I'm not sure if this is 100% what you want, I may need a better explanation, but, perhaps it will get you going in the right direction.

Happy Holidays,

Al

VastagoRoyaltiesV2.zip

Thanks, I think it's pretty much what I needed, however when I look at the address layout I cant see the names of the author, producer or artist created, I just see the address. Also, when I look at the file in Layout mode all my fields say things like "powerful scripts" "customizable buttons" and things like that instead of the actual field name. How can i take that off.

Thanks.

First, in layout mode go to View>Show>Sample Data and uncheck. That's a method to use to make sure your relationships are working. You will see the correct data in the fields while in layout mode.

Next, I played with the name problem and perhaps someone with more experience can figure that out. Since you have 3 separate tables for Artist, Author and Producer I could not get the name in the address layout. Personally, I would have set up one table with a "Type" field and set my relationships based on type. Then I could get the data from any related table Occurrence. But, I didn't want to re-write your solution.

HTH

Al

I thought about the type field but then didn't know how to handle the fact that sometimes one person can be an author, a producer, or an artist, and that this person can appear in one or more albums or songs and I dont want to duplicate all that data.

Thanks for all your help

You could have three tables: Works, People and Credits. The Credits table is a join table between Works and People, and could look something like this:

CreditID: 75 (auto-entered serial number)

WorkID: 24

PersonID: 56

Credit: Producer

RoyaltyShare: 25%