Problem of links between two tables

Hi there -

For future reference, you want to create the reference field in the table that will have many records to 1 record in another table. Since you want to be able to have 1 musician for many bands. You would create a reference field in Band to musicians.

Now when you go to a record in musician, you will see a link view to band with the ability to add existing record or create a new one.

If you go to the band table and look at a record you will see that 1 band record is linked to 1 musician.

Can I ask, what will you do about different musicians belonging to the same band?

Hi

If you can say "There can be more than one musician in a band" and "A musician can play in more than one band" then you have a many to many relationship between musicians and bands. This needs a third table, typically called a join table. It has a one to many relationship with bands and a one to many relationship with musicians, with the many side of both relationships in the join table. There will be a record for each instance of a musician in a band, so if there are three bands and three musicians and each musician plays in each band it will have nine records.

Regards John

5 Years of Suspension Wiped Away In One Month

Helping Drivers

License Restored PA
Client “C” came to me with almost 5 years of license suspension in Pennsylvania. His driving record was a mess with old tickets from all over. Things did not sound good at first, but after our investigation, we found a PennDOT error that needed to be fixed.

Years of experience were used to determine that the error occurred when PennDOT calculated the suspension time. At first, PennDOT was reluctant to correct the error because the calculation of suspension time and credit date seemed correct, but after a careful petition was submitted, the eligibility date was changed so “C” was able to get his license back within a month rather than 2019.