MS Access question......

[flamin_skull]

I have created a dummy database of a video store to get an idea of the software, and I have created two tables, Video Information and Loan Information.

I would like to make a field where you can tick whether the video is available or whether its being rented. But i want the same field in both Tables, and I want it so that if you uncheck the avialable box of a movie in one of the tables, it changes in the other also.

Here are screenshots of the two tables;

Loan Table

Video Table

You can see the availability field in the Video Table, but I want the same one in the Loan Table, and the fields to be related so when you uncheck it in one table, it unchecks in the other vice versa.

Can anyone help??

 

[patrickv]

It's not complex, you will need to create a relationship, you need to link returned and Available together.
what type of box are they ?? yes/no fields or Checkboxes ?

cause i just did one now using YES/NO field and link them and it works, checkboxes might be different

here is my example i did.
Form after creation, fields blank


here's the form after i checked the On rent field


here's the relationship


hope it helps mate