Dlookup or similar to get the right values

[buddhagui]

I have an access 2000 app that I am creating a subform. This subform has data
from two tables:

BidHistory
--------------
Bid
OrderID

Orders
-----------
CustomerInfo etc
OrderID

In detail, how can I get the subform to only show the lowest bid, then in the
same row, the customer information. There will be many bids for each orderID
all in BidHistory?

Please help.

Thank you,
Chris

 

[Duane Hookom]

You can't show "the lowest bid" since it seems you don't have any numeric or
other required fields in your tables.

 

[Guest]

Getting the lowest bid is easy enough:
=DMin("[bid]", "BidHistory", "OrderID = '" & Me.txtOrderID & "'")

The above assumes OrderId is a text field. If it is not, the syntax would be:
=DMin("[bid]", "BidHistory", "OrderID = " & Me.txtOrderID)

The problem with getting the customer info is, I see nothing that ties the
bid to a specific customer.