Good Evening. I have a form with three sets of cascading combo boxes.
1st set consists of genres which controls selection of Sub-genres.
2nd set consists of classification which controls selection of sub-classification.
3rd set consists of Continent which controls selection of Country which in turn controls selection of Location.
All combo boxes are unbound.
There are 3 bound text fields (ID, Title and Location)
There are 2 bound combo boxes (artist and composer).
My problem is this. Once I use the cascading combo boxes to make a selection that selection appears the same in all following records.
i.e. 1st cascade genres reads Folk, sub-genres reads NO SUB GENRES
2nd cascade classification reads TRAVEL, sub-classifiaction reads TRAIN
3rd cascade continent reads AUSTRALASIA, country reads AUSTRALIA location reads NULLABOR.
These entries will show on all the records and if i change one or all entries on any record (I have 5 at the moment) the change appears in all records.
The object of this database, which is my first attempted at creating my own, is to hold information on all the music i have for use in the sound tracks of homemade holiday and travel DVD's. I am a complete novice at databases but have managed to get this far with books and online documention. Ultimately i will want to be able to search by selected criteria and previes a tune prior to inporting it into my video editing programme. Hence any help wouldbe greatly appreciated.