Availability on stock?

[TCom]

1. I have ave a rental form based on a rental query. I have an availability field in the query. how do I go about updating the availability once the video is rented? How do I link this to the underlying table so that this is also updated?
2. I then have a "Video return form" - hoe would I create a macro that demonstrates that the the video is available again??

Thanks TCOM

 

[SimonDavis]

You could use a checkbox - on the table set the field properties to a yes/no, and on the form you can put the check box to indicate if the video is in our out.

To filter the checkboxes, use 'true' or 'false' as the evaluation criteria.