shortstuff2212
Programmer
I have the following tables in an Access db.
Table - ElectoralArea
ElectionID ElectorLevel Polldistrow EACode
1 Ward DistrictWard CAD
Table - PollingDistrict
PDCode DistrictWard County Parish
AA CAD HU ST
AB CAD HU ST
AC CAD HU ST
AD CAD HU ST
BA CAD HI SB
BB EAB HI SB
Table - PollingStationRange
PSCode PDCode PSNumber Electorate
2212 AA 1 1-1999
2215 AB 2 1-1999
2218 BA 3 1-1999
I need to find out what data is in the Polldistrow field and then take the EACode and find the same code in the relevant field in the PollingDistrict table and store the PDCode then find all the pollingstations with the same PDCodes and display them on the report.
Can anyone help with this as I have never used variables in crystal reports and I am really stuck on how to do this.
Any help would be greatly appreciated.
Table - ElectoralArea
ElectionID ElectorLevel Polldistrow EACode
1 Ward DistrictWard CAD
Table - PollingDistrict
PDCode DistrictWard County Parish
AA CAD HU ST
AB CAD HU ST
AC CAD HU ST
AD CAD HU ST
BA CAD HI SB
BB EAB HI SB
Table - PollingStationRange
PSCode PDCode PSNumber Electorate
2212 AA 1 1-1999
2215 AB 2 1-1999
2218 BA 3 1-1999
I need to find out what data is in the Polldistrow field and then take the EACode and find the same code in the relevant field in the PollingDistrict table and store the PDCode then find all the pollingstations with the same PDCodes and display them on the report.
Can anyone help with this as I have never used variables in crystal reports and I am really stuck on how to do this.
Any help would be greatly appreciated.