My collection was on Microsoft Access, which I designed, comprised of 3 sections all interlinked as shown: -
Input was via one screen incorporating the above.Reports were made for: -
I have been able to transfer the information as shown in Nos. 1, 2 and 3 with the auto numbering where necessary. The relationships have been connected - Artist ID (in No 1) in to Artist ID (in No 2) then Recording ID (in No 2) to Recording (ID in No 3).
So far so good as they say.
Where I am stuck is: -
Creating the single input for all the album information and the reports. The track times are used for when creating AV Shows with digital images to ensure the track length, images, sound effects and spoken word all fit.
So near yet so far as they say.
Any assistance would be much appreciated, if you require more information just let me know.