AnsweredAssumed Answered

Help making a Beekeeping tracking database

Question asked by king_arthur on Jun 18, 2017
Latest reply on Jun 18, 2017 by philmodjunk

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

 

thanks

Outcomes