Sub Form field blanking screen help w\DLookup

[ScottieK]

Please can you help with code for following problem?

I have this table, short example, where the discount matrix lists the various
discount structure. I need the CustD1 to show the correct value in each line
item of a repeating panel for the Sub Form SF010_SODetails. The SF010 is a
tab screen in the main F009_SalesOrders form.

My product line item discount depends on each Customer, T01_25_UserCode data
in T01_Company and also each product ordered T11_61_ItemSchedule data in
T11_Item_Master.

The following query works great but to much info, but does pull code for each
sales order. MAIN PROBLEM, if I try to add the discount % to use from here it
blanks out my sub form detail section so a blank screen shows. T705 also will
duplicate to much data.

SELECT Q012_SODetails.Customer, Q012_SODetails.T11_01_Part_Number,
T58_CustDiscount.CustD1, T58_CustDiscount.T11_61_ItemSchedule,
T58_CustDiscount.T01_25_UserCode, *
FROM (T01_Company INNER JOIN (T11_Item_Master INNER JOIN T58_CustDiscount ON
T11_Item_Master.T11_61_ItemSchedule = T58_CustDiscount.T11_61_ItemSchedule)
ON T01_Company.T01_25_UserCode = T58_CustDiscount.T01_25_UserCode) INNER JOIN
Q012_SODetails ON (T01_Company.T01_PK = Q012_SODetails.T01_PK) AND
(T11_Item_Master.T11_PK = Q012_SODetails.T11_PK)
WITH OWNERACCESS OPTION;

Can you help me with the code for a DLook up; I think this may work so I have
tried several times but can’t get it.

Thank You