Hi
I am creating a database for a games rental system. I have one table which is titled 'Games' and another which is titled 'Game Copies'. To add a Game Copy, you must first add the Game in to the Games table. This will mean entering a title etc. When you then go to add a game copy, there is a combo box which will drop down and show all the current titles from the Games table so that you can select the game you want and add a copy of it to the Copies table.
In the Games table, there is an attribute for 'Copies Held'. Is there some way that i can have the database count how many copies of the Game are in the 'Game Copies' table, and display it in this field?
Thanks, Jamie.