[dba-SQLServer]ADP form based on 1-to-many SQL statement

Further to my note last night - Here is the SQL from the view that I am using -

SELECT   DISTINCT  tblCustomers.TradingName END AS CustName,
                       tblCustomers.Residential, tblCustICP.ICPNumber, 
tblCustICP.AllocationGrp, tblCustomers.PAddress1, tblCustomers.PAddress2, 
tblCustomers.PSuburb,
                       tblCustomers.PCity, tblCustomers.PPostCode, 
tblCustICP.GateIDNo, tblCustMeter.MeterNo, tblCustMeter.MeterModelIDNo, 
tblCustMeter.Location,
                       tblCustMeter.NoOfDials, tblCustMeter.DigitsRead, 
tblCustMeter.Pressure, tblCustMeter.LastYrConsumption, 
tblCustMeter.DateMeterLastRead,
                       tblCustMeter.OldRetLastMeterRead, 
tblCustMeter.ActualEstimateOld, tblCustMeter.OldRetailMultiplier, 
tblCustMeter.InstallID,
                       tblCustMeter.DateMeterInfoRecd, 
tblCustMeter.LastMeterReadDate, tblCustMeter.LastMeterReading, 
tblCustMeter.MthEstimateUse,
                       tblCustMeter.PressureKPA, 
tblCustMeter.PressureFactor, tblCustMeter.Corrector, 
tblCustMeter.MeterMult, tblCustMeter.ConversionFactor,
                       tblCustMeter.NextMeterReadDate, 
tblCustMeter.ConxnNRDDate, tblCustomers.AccStatus, tblCustomers.InvNumber, 
tblCustomers.CurrentBillDate,
                       tblCustomers.CustomerID
FROM         tblCustomers INNER JOIN
                       (tblCustICP INNER JOIN
                       tblCustMeter ON tblCustICP.ICPID = 
tblCustMeter.ICPIDNo) ON tblCustomers.CustomerID = tblCustICP.CustIDNo

Any suggestions?


Regards

David Emerson
DALYN Software Ltd
25b Cunliffe St, Johnsonville
Wellington, New Zealand
Ph/Fax (877) 456-1205