I'm not sure of what you mean with the current version because the current version is the one that you are working on.
I haven't done any adding of record sins I've posted it to the forum
Although I have tried to be careful, it is very likely I have or will edited the data while testing. So I may not be the same as your good data. The beauty of the Split db is that I can do whatever I want to the data and send the FE back to you without worrying about messing up your data. Plus you can continue editing while I am working.
What did you fix? I dont see the difference.
Test the below, it should be fixed
I noticed that the song disappears from the field in the form until I put the artist there, a little annoying but you get used to it.
I did not see any sort issue problems, because what you describe already appears in the version I had. You are correct you cannot sort
A1, A10, A11, A2, A3...
You do have to sort the disc side A, B, C then the track 1,2,3
But this was working in my version.
The split is interesting, I've read about it. But I thought I've change all the names first.
But at the same time it would still be possible to change them after the split.
It really does not matter, but if you are still working with the table design then you can hold off on splitting the database. But once it gets pretty solid I would split it.
I personally am not so concerned about the names, but I would Strongly reconsider the junction tables for artist_record and artist_music. IMO these add more pain then benefit. In truth, I think logically these junctions are wrong. I would have a single artist "Donna Summers and Barbara Streisand". IMO that is a single "aritst". It is not Donna and Barbara as child records.
If you want child records so you can see the details of each artist then make a child table to artists.
tblIndividualArtist
CombinedArtistID_FK
IndividualArtistID_FK
So if BS is ID of 1, and DS is ID of 7 and "DS and BS" is ID of 15 then you would have values
15 1
15 7
In truth I doubt you would even really need to do something like this.
So I have a collaboration of Alison Kraus and Robert Plant in my tracks. My details on the artist are on the collaboration and not the each artist. I have a single image of both and not two seperate images.
If you do not do it this way you will have to do complex concatenations and searches. Using what you have in the treeview I get seperate albums under BS and DS which is not true. To then do the concatenation in the treeview would be really painful.
Now if you see my form I can search the database by name. So if I search DS then all of Donna's tracks come up as well as collaborations.