n : n Relation

[Viktor]

Hi!
I'm quite new with DOA, and I was wondering, how I can implement Tables in n:n Relations.

Say, we have 3 TOracleDatasets, LKW, LKW_Driver, Driver.
Here, the DataSet (Relation) LKW_Driver would have to be a Detail Dataset to LKW and Driver. With the "Master" property, I guess, one can only set one DataSet to be Master, right?

Whats the most appropriate way to solve this?

Thanks!

 

[Marco Kalter]

One possibility is to define LKW as the Master dataset, LKW_Driver as the detail dataset, and Driver as a lookup dataset. You can also choose not to use the standard Master/Detail functionality, and create a form where the LKW_Driver dataset has 2 masters. You have to program your own Master/Detail synchronization events though.

------------------
Marco Kalter
Allround Automations