Good afternoon.

We have 2 tables - Purchase and Statement.  All fields are populated from a lookup.  I would like forms to compare values in Purchase.RowID with Statement.Confirmation.  If it finds matches, then highlight the rows.

I think I can get the highlight the rows working.  However, I am not sure how to program the lookup portion.  Any help would be greatly appreciated.