Database Structure and linking data

Need help Database
1

I am working on a directory for golf clubs and golf courses and I am struggling with how to link the two together. A golf club can have multiple golf courses attached to it but a golf course can only have one golf club.

The data type ‘Golf Club’ each club as a specific Facility ID field.
The data type of ‘Golf Course’ each course has a Course ID that is an extension of the Facility ID. I also have the corresponding Facility ID as a data field for Golf Course.

Do I make a list under the Golf Club data type that is a list of course id or do I make a list of facility id under the Golf Course data type.

facility id

image
image677×652 17.1 KB

2

Hey @wireaffiliates, with both of your data types for ‘Golf Club’ and ‘Golf Course’ created, under the ‘Golf Club’ data type add a new field called Golf Course and make it of type ‘Golf Course’ and make it a list of things. Then under the ‘Golf Course’ data type add a new field called Golf Club and make it of type ‘Golf Club’ and leave the list of things unchecked.

Like this Loom | Free Screen & Video Recording Software | Loom.

Without knowing your full use case here, I’m not so sure the Facility ID or Course IDs matter much. This is because as long as you have linked the specific Golf Courses to the specific Golf Club in your database – and each specific Golf Club to the corresponding Golf Courses – you’ll be able to easy display, for example, all of the Golf Courses related to a golf club. The actual how-to for this is below:

This first part of the tutorial explains an analogy I believe is quite similar to your use case:

https://www.youtube.com/watch?v=5yJfk-MXu54&t=130s – in my world I use Bundles that have Classes in them. Bundles have multiple Classes and yet Classes only have one Bundle.

You’ll want to make sure the primary fields are setup with the titles of the gold course or club like in https://www.youtube.com/watch?v=5yJfk-MXu54&t=585s.

And finally, you’ll want to link the two data types to each other like in this part https://www.youtube.com/watch?v=5yJfk-MXu54&t=1438s.

Good luck. Reach out to me on DM if I can be of any more help.