I'm starting with Open Access ORM and i'm making some experiment to try to understand how to work efficiently with it. But it's not clear at all.
Let say i have a class Customer and a class CustomerContact. There can be many CustomerContact for a customer. So in the reverse engeneer wizard i selected both class and went to the client reference into CustomerContact class to check the one to many relation.
When i add Customer it work fine. If i add a CustomerContact to the CustomerContact collection from Customer it does not work. I have to reference and existing Customer before adding it to the collection???
Honestly, the fact of adding the CustomerContact to this collection should be enough to associte them. Am i missing something?
Another Question is What is the best way to create those relation? In visual studio ado net we have a nested relation that work fine? There is nothing like this in ORM? When i try to add Customer as datasource, i see contact but like a field, not like a nested table