I am relatively new to filemaker and needed some help teasing out a project i am planning on building. I am a hobby beekeeper and I want to create a database to track our hobby activities, apiaries, hives, equipment, honey harvest, etc. while I have a concept I am getting stuck on the join table stuff and I would love if someone could help me tease this out.
so I am going to start here on a very basic level. I have two tables: Apiary and Hive
Here is my problem:
1. An Apiary can have one to many Hives
2. A Hive can only belong to one Apiary
I get if is make a direct relationship from Apiary to Hive I can then only have one related table, well obviously that doesn't work. Cause a single Apiary may have 8 Unique Hives. So I am stuck with the Join table line item stuff...
the second part part of the problem is if for some reason I have to move a hive from say Apiary 1 to Apiary 2 I can make that change as well.
I will start with that I am sure I will have more questions as I build forth