master/detail tdbf .9.8.0

[mtdew3q]

Hi-

I am having trouble getting the master detail relation to work.

Here are my settings:
Datasource3: dataset dbf3
Dbf3 Tablelevel 7
tableName Status_Master.dbf

Datasource4: dataset dbf4
Dbf4 Tablelevel7
tableName Status_Detail.dbf
MasterSource: Datasource3
MasterFields: ID
IndexName: idxstatus

Here are the table structures.
MasterTable
ID        L       4
Expense C    30

DetailTable
ID_AUTO  +
ID      L         4
Amount Float
Status  C  4

ID is a primary key in master
ID_AUTO is a primary key in detail

One secondary index is named idxstatus in the detail.
It has ID specified for a field.
it is maintained but not unique.

i dropped 2 grids on the form.
one set to datasource3 and one set to datasource4.

i thought as i scrolled through datasource3 -> gridMaster
i should see changes in grid hooked up to datasource4(detail)
with these settings but nothing is happening.

i use paradox to input the settings for the dbase table like table type and restructure + index stuff.  i am lucky i just happened to have a copy.

any ideas?  sorry but i am stuck.


thanks,
jim

[Anonymous]

going once ....going twice...
i hope my question wasn't too far off base.
i'll wait until friday night to see if anyone has something to say.
if not, i will just use the sqlite component.

i havent really written any serious code yet so no harm switching if i have to.

thanks,
jim

[RudieD]

I usualy just call a procedure in the Master dataset's AfterOpen,AfterPost and AfterScroll events that reconfigures the Detail DataSet.

Hope it helps !

[Anonymous]

Rudie-

that is an interesting idea.
thanks for the tip.

jim

[Anonymous]

the filterRecord event isnt working either.  unless i am doing something wrong the
db stuff is definitely in progress.  maybe in a half year or so i can try again.
i am still very interested in this project and will be back again.

thanks everyone,
jim