You have a one to many relationship from Apiary to Hives:
Apiary::__pkApiaryID = Hives::_fkApiaryID
__pkApiaryID should auto-enter get (UUID) into a text field with the "Do not replace..." check box cleared or a number field that auto-enters a serial number. _fkApiaryID should be a text (UUID) or number (serial #) field.
No join table needed.
Thanks that was what I did.. and i see i used the wrong table in the portal to add the hives to the Apiary...
Now the only other thing with regards to this relationship i need help with is I want the Hive record to also contain what Apiary it is in.
For Example in a Hive Record:
Hive::Name_Apiary -this is pulled from the Apiary::Name_Apiary
The problem is probably in my thinking in relationship direction. I have a Layout that Shows Records from Hive table i cannot figure out how to get the Apiary name to show in the Individual related Hive Record.
thanks again... i am slowly getting the hang of this...
You don't need that field, you already have it in your Apiary table and can use it. As long as there's no unindexed field used as a match field, and you don't have that here, relationships work both directions.
Once you have linked a Hive to an Apiary by selecting the correct _fk value, You can simply add the Apiary::Name field to a layout based on Hive and it will show the current Apiary's name. If you move the hive to a different Apiary and update the _fk field to the new Apiary ID, this name will automatically update as it will now show data from a different Apiary record.
Ps: My family farms almonds and we really rely on you folks for our crop. Hope your hives stay healthy and productive!