A friend and I have developed a Music Publishing program and I'm stuck in a couple of places. We have Contact Management, but we also have a file for Contract-Briefs for our individual songwriters. In another layout we have our songs. We have the Song Title, then we have a portal with the writers, and publisher information, including the splits (percentage) of each writer and publisher......Once the song information has been entered, we need to link that song to the individual songwriters Contract-Brief. This is where we're stuck.
Can you help me? Scripts, what kind of field to link the song to, etc. We also need to keep a total of the percent the writer has for each song, but I think that is a simple Sum Calculation.
Thank you so much.