I have a table that holds customer orders. It is linked to a table that holds years. The [years] table has one field "years" and it is the PK.
The orders table has the FK "years". Every customer can only have one order per year.
The field "year" in the orders table holds a 4 digit value (ie. 2009). I would like to create a Qry that would show me only orders in the current year so that next year my orders from 2009 no longer show in the Qry.
Can this be done?