Please fix my problem's report

[pedjvak]

Hi Every body
I attach a file which contain my database
please open the "fit up report" you see !!!
when you open it it asking you 4 times for enter data I don't know why ?
if you can fix it and tell me why it make?
maybe you have a better way to get same report if you have idea please show me


thanksDatabase1.mdb

[June7]

Probably because the report/subreports are not linked on primary and foreign keys.

Instead of subreports, try this query as RecordSource for a single report:

SELECT [Fit up].*, Material.[Type Of Material] AS StartType, Material.[MR No] AS StartMR, Material_1.[Type Of Material] AS EndType, Material_1.[MR No] AS EndMR
FROM Material AS Material_1 RIGHT JOIN (Material RIGHT JOIN [Fit up] ON Material.[Heat No] = [Fit up].StartHeat) ON Material_1.[Heat No] = [Fit up].EndHeat;

[pedjvak]

Dear June7
thank you so much
you are the best its work