Here is a question, I do not even know where to begin.
I have a database that helps my son and I track a collection of hot wheels cars. In the database, I have a Collection table and I have a Master List table with all the vehicles from 1968 to present. Each vehicle has a name, series, year of release, a collection number, and loose and packaged values.
What I want to do, is have a form that allows me to select the Year from a combo, which populates another combo or list with the Series available for that year, then in a list box or a continuous sub form or something, I want the vehicles related to that series for that year to populate so my son and I can track whether we have a complete set or which vehicles are missing, etc.
I have been trying to think of how to do this, but really cannot figure out where to begin. Any guidance would be appreciative!
Thank you,
KJL
I have a database that helps my son and I track a collection of hot wheels cars. In the database, I have a Collection table and I have a Master List table with all the vehicles from 1968 to present. Each vehicle has a name, series, year of release, a collection number, and loose and packaged values.
What I want to do, is have a form that allows me to select the Year from a combo, which populates another combo or list with the Series available for that year, then in a list box or a continuous sub form or something, I want the vehicles related to that series for that year to populate so my son and I can track whether we have a complete set or which vehicles are missing, etc.
I have been trying to think of how to do this, but really cannot figure out where to begin. Any guidance would be appreciative!
Thank you,
KJL