Update one table based on entry in another table

I am selling and loaning baby carriers.

I need to remove carriers from the Report "Carriers in Library" after they
have been sold. (I.e., when a carrier ID is entered on the SALES table,
change the field "AVAILABLE" from Yes to No on the Carriers table.)
- Likewise, when a carrier ID is entered on the LOANS table, I need the
CARRIERS_AVAILABLE from Yes to No

Consider a different approach .......

Add a field named "DateReturned" to the loans table. Create a query named
QryCarrierLoanReturned based on the loans table. Set the DateReturned field
criteria to Null.

Create an unmatched query that finds all the CarrierIDs in the carrier table
that are not in the sales table AND not in QryCarrierLoanReturned. This
query will list all the carriers available for sale or loan. Use this query
for the recordsource for your report.

Steve
santus.DeleteThis@penn.com


"nemawei" <u55528@uwe> wrote in message news:9db4c9643da66@uwe...
>I am selling and loaning baby carriers.
>
> I need to remove carriers from the Report "Carriers in Library" after they
> have been sold. (I.e., when a carrier ID is entered on the SALES table,
> change the field "AVAILABLE" from Yes to No on the Carriers table.)
> - Likewise, when a carrier ID is entered on the LOANS table, I need the
> CARRIERS_AVAILABLE from Yes to No
>