NeilPattison
IS-IT--Management
I have a table that has the fields Scheme no, Title, Area, Pole No, Rate No, Description, Quantity. Each Scheme No has a number of Poles attached to it, and subsequently each Pole has a number of different rates attached (eg of table shown below)
On the corresponding form I have ID No, Title and Area in the Form header as they are the same for all fields. Therefore in the detail section I want the rest of the fields. The problem I have is I want the user to be able to choose a pole no from a combo box and show up only the corresponding rates to that pole. So for instance below the user could select in the combo box Pole no YP08 and only the rates used on that pole would show up (in this case it would be just HV99 and its description).
SchemeNo Title Area Pole Number Rate Description etc
001 xxx UK YP26 LV01 xxxxx
001 xxx UK YP26 HV89 xxxxx
001 xxx UK YP08 HV99 xxxxx
001 xxx UK YP09 YG67 xxxxx
001 xxx UK YP99 LG45 xxxxx
I hope this makes sense to you. Any help with how I can set up this combo box would be greatly appreciated
On the corresponding form I have ID No, Title and Area in the Form header as they are the same for all fields. Therefore in the detail section I want the rest of the fields. The problem I have is I want the user to be able to choose a pole no from a combo box and show up only the corresponding rates to that pole. So for instance below the user could select in the combo box Pole no YP08 and only the rates used on that pole would show up (in this case it would be just HV99 and its description).
SchemeNo Title Area Pole Number Rate Description etc
001 xxx UK YP26 LV01 xxxxx
001 xxx UK YP26 HV89 xxxxx
001 xxx UK YP08 HV99 xxxxx
001 xxx UK YP09 YG67 xxxxx
001 xxx UK YP99 LG45 xxxxx
I hope this makes sense to you. Any help with how I can set up this combo box would be greatly appreciated
