Hello there,
I have a form with 3 combo boxes. The first combo box will populate the master records. if the user select any record from the first combo box the second combo box will populate the detail records.
Example Data:
Table: Building (Master)
Bldg_Code Bldg_Name
Table: Building_Floor (Detail)
Bldg_Code Bldg_FloorCode Bldg_FloorDesc
1---------------1---------Ground Floor
1---------------2---------First Floor
1---------------3---------Second Floor
2---------------1---------First Floor
Table: Building_FloorFlat (Detail)
Bldg_Code Bldg_FloorCode Bldg_FloorFlatCode Bldg_FloorFlatDesc
1---------------1----------------1----------Flat Number 1
1---------------1----------------2----------Flat Number 2
1---------------1----------------3----------Flat Number 3
I'm a beginner in vb.net, Hoping you can provide a source program solution.
Thanks,
Rock
I have a form with 3 combo boxes. The first combo box will populate the master records. if the user select any record from the first combo box the second combo box will populate the detail records.
Example Data:
Table: Building (Master)
Bldg_Code Bldg_Name
1----------Building Number 1
2 ---------Building Number 2
Table: Building_Floor (Detail)
Bldg_Code Bldg_FloorCode Bldg_FloorDesc
1---------------1---------Ground Floor
1---------------2---------First Floor
1---------------3---------Second Floor
2---------------1---------First Floor
Table: Building_FloorFlat (Detail)
Bldg_Code Bldg_FloorCode Bldg_FloorFlatCode Bldg_FloorFlatDesc
1---------------1----------------1----------Flat Number 1
1---------------1----------------2----------Flat Number 2
1---------------1----------------3----------Flat Number 3
I'm a beginner in vb.net, Hoping you can provide a source program solution.
Thanks,
Rock