I have 4 tables that I use in the set. The Primary is the Year, Month, Month Description table. The fields are:
1) mst_yr c 4
2) mst_mth c 2
3) mst_desc c 10
The 2nd table is a Category table which fields are:
1)int_mth c 2
2) int_catg c 40
The 3rd table is a Sub-category table which fields are:
1) int_2_mth c 2
2) int_catg c 40
3) int_2_catg c 40
My last table is the transaction table which fields are:
1) det_mth c 2
2) int_catg c 40
3) int_2_catg c 40
4) det_desc x 40
5) det_date Date
6) det_paid _to c 40
7) det_paid_amt n 10 2
My set structure now is:
Primary table is: mst_tbl
Parent Key is mst_mth 1 to many linked to
Child table which is: int_tbl
Child Key is int_mth 1 to many
The next link is to my Sub_catg Table:
Parent Table is int_tbl
Parent Key is int_mth 1 to many
Child Table is int_2_tbl
Child Key is int_2_mth 1 to many
The final link is to my Detail Table:
Parent Table is int_2_tbl Detail table is det_tbl
Parent Key is is linked to multiple fields:
Parent Table--Child Table
int_2_mth = det_mth
int_2_catg = int_2_catg
int_catg int_catg
See my attached example:
When I click on 2010 01 and select Income from the Category Browse, I expect to see all Sub-Category for the month of January in the 2nd browse window named Sub_category.
When I click on a Sub_Category entry in the browse Window such as Marion Security I expect to see all entries for Marion Security for the month of January in the 4th Browse window which are the details. If I click on Pensions from the Sub_Category window, I should see all January details for Pensions. This seems to me working.
When I click on Entertainment in the Category Window, I should see Net Flix and Eat Out in the Sub_Category window however I do not. The Sub_Category's for Income and it's Details remain.
Can someone define the correct links for me. I've spent a lot of time and have a mental block on this issue. I had no problem linking 3 tables however when I added the 3th table, this problem occurred.
Thanks,
Rudy
1) mst_yr c 4
2) mst_mth c 2
3) mst_desc c 10
The 2nd table is a Category table which fields are:
1)int_mth c 2
2) int_catg c 40
The 3rd table is a Sub-category table which fields are:
1) int_2_mth c 2
2) int_catg c 40
3) int_2_catg c 40
My last table is the transaction table which fields are:
1) det_mth c 2
2) int_catg c 40
3) int_2_catg c 40
4) det_desc x 40
5) det_date Date
6) det_paid _to c 40
7) det_paid_amt n 10 2
My set structure now is:
Primary table is: mst_tbl
Parent Key is mst_mth 1 to many linked to
Child table which is: int_tbl
Child Key is int_mth 1 to many
The next link is to my Sub_catg Table:
Parent Table is int_tbl
Parent Key is int_mth 1 to many
Child Table is int_2_tbl
Child Key is int_2_mth 1 to many
The final link is to my Detail Table:
Parent Table is int_2_tbl Detail table is det_tbl
Parent Key is is linked to multiple fields:
Parent Table--Child Table
int_2_mth = det_mth
int_2_catg = int_2_catg
int_catg int_catg
See my attached example:
When I click on 2010 01 and select Income from the Category Browse, I expect to see all Sub-Category for the month of January in the 2nd browse window named Sub_category.
When I click on a Sub_Category entry in the browse Window such as Marion Security I expect to see all entries for Marion Security for the month of January in the 4th Browse window which are the details. If I click on Pensions from the Sub_Category window, I should see all January details for Pensions. This seems to me working.
When I click on Entertainment in the Category Window, I should see Net Flix and Eat Out in the Sub_Category window however I do not. The Sub_Category's for Income and it's Details remain.
Can someone define the correct links for me. I've spent a lot of time and have a mental block on this issue. I had no problem linking 3 tables however when I added the 3th table, this problem occurred.
Thanks,
Rudy
Comment