master/detail tdbf .9.8.0

Forum > Databases

(1/1)

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

Navigation

[0] Message Index