Using Master/Detail

[J_Pygram]

I have 2 tables which are linked by a foreign key on a field called USER_ID. I have also 2 TOracleDataSet components and I want to create a master/detail form. In the detail DataSet I have set Master correctly and have been prompted to accept the DetailFields and MasterFields property which were set correctly. However, when I try to open the detail data set I get the message that "Variale: USER_ID not declared". I have tried all sorts of things but am obviously missing something.

John

------------------
John Pygram[/u]
JPygram@aol.com

 

[Robertio]

In your detail table you have to have a where clause, ie:

select * from user
where user_id = :user_id

Then declare the variable user_id in the datasets variables property. This is needed to link your master & detail tables.