Display highest value in a numeric series by dmax or a query
Posted on 2011-05-02
I have two tables in two forms. CustomersTbl in form, customerfrm and transactionsTbl in sub form,transform.
The forms are linked by the numeric fields, customerNo (customertbl) and custno (transactionstbl)
Each customerno has several transactions
I want to see the highest transaction number used by a customerno that is currently being displayed. For example, if user is editing customer 2233, a text box will display 6.
I tried dmax(“transactions”,”transactionstbl”,”custno = [customerno]”)
And other combinations but no luck yet. Maybe dmax is not suitable since there are two tables. Any help will be appreciated.