How do I made the association?
data Type Samples
Field UniqueMeasurementID (=Monstermetingen Unique Measurement ID)
Field UniqueSampleID (=MonsterBasis Unique Sample ID)
When you create a database field, you may set the field type to text, number, date, etc. You can also set the type to another data type (table) in your database such as Monstermetingen or MonsterBasis. These are called ‘custom types’ and are other things in your database.
Your custom types are found below the built-in types. Scroll down to the bottom to find your custom types when selecting the field type from the dropdown.
As far as how you associate them.
You can do this manually in the data tab under ‘app data’ in the bubble editor. In practice, you’ll want to be able to do this in your app too. For example: In your bubble workflows you can:
Step 1) create a sample thing in one step
Step 2) update a MonsterBasis thing
MonsterBasis's associated Sample = Result of Step 1 Create A Sample
Step 3) update a MonsterMeetingen
MonsterMeetingen's associated Sample = Result of Step 1 Create A Sample
What you’ve got going on here with Samples is slightly beyond the basics of just storing stuff in the db. Samples is a ‘carrier data type’ which the things inside do not really store much on their own, but really function to store the relationship between two other things MonsterMeetingen and MonsterBasis
You’ll likely want to learn more about the basics of relational databases. I’d highly recommend checking out Salar’s Udemy Course to which covers more more on the database and this kind of thing.