Query

[abc]

Connected to Access backend.

Main Connection includes: Detail (parent table- recordID, and other
fields) and UnitDetail (child table- record ID, UnitDetailID, Unit)

Secondary Connection includes: Unit (table- list of Unit names)

Query section:
I have a drop down list bound to the main connection (Q:UnitDetail-Unit
(field)). Added the secondary connection for the drop down.. for users
to see the list of different Unit names.

Data section:
I have a textbox (repeating) bound to the main connection
(D:UnitDetail-Unit (field)).

Everytime I query with a 'unit' it pulls up every single record.
PLEASE HELP!