Query Setup / Report

[majid.pervaiz]

Dear All,

i have a query which is getting generated (byBusno) and i have a form (ByBusNo) where there is a drop-down and showing bus number based on the query.

i dont know why in drop down duplicate numbers are appearing plus when the report (Routeinfo-busno) is generated it is not getting generated based on the selection in drop down.

Additionally, the report is taking bus_no as input again which i can't figure out why this input message is coming.

I am attaching database for reference, can someone please guide me.

many thanks in advance.

 

[Ranman256]

in the combo box query, change the setting to :UNIQUE VALUES = TRUE
the sql will say SELECT DISTINCT so no duplicates will happen.