This is driving me insane :-(. I truly can not get my head around how relationships work in Adalo and I have spent 48 hours trying to figure it out.
I have 3 collections:-
See schema and relationships below.
I am unable to update the relationship field in Production Jobs - I just get an infinite number of options and can’t click on a field name to select it.
Should relationship fields update automatically when a new record is added to the first collection or do you have to force a field to update the relationship?
Any ideas please?