Master/Detail Relationship

[Eric^2]

I'm trying to set up a master/detail relationship with two TOracleDataset components. I keep getting a "Variable Not Defined" error (with the name of the master or detail field) and can't seem to get it to work. I've verified all the items in the help file to no avail. My two tables (for testing) are A(KEY NUMBER(3), VALUE VARCHAR2(10)) and B(KEY NUMBER(3), A NUMBER(3), VALUE VARCHAR2(10)). There is a proper PK/FK relationship across A(KEY) and B(A). How do I set this up to make it work correctly?

 

[Eric^2]

Of course 5 minutes after I posted that I couldn't figure it out, I figured it out. I didn't realize I had to define a variable for TOracleDataset to populate. I just assumed that it did that by iteslf. BTW: The Debug feature is quite nice!

 

[Marco Kalter]

Actually, if a foreign key constraint exists between the master and detail table, then all properties that make up the master/detail relation (including the variables) should automatically de defined at design time when you link the datasets through the Master property of the detail dataset...

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