I’ve got a very odd data model so far.
I’ve got a files table with a compound primary key made up of a name and an extension.
I’ve got a songs table whose primary key is the compound foreign key from the files table.
Now the reasoning is that a partiular song “Foo” may have the actual song file that can be edited in software, example “Foo.xm” and that same song may have an mp3 file “Foo.mp3” for preview.
I need to allow multiple files with the same name but different extensions in the Files table. However, I would like to only allow 1 song with a particular name in the songs table. The unique box is greyed out. How can I accomplish this?
If confused, please take a look at the attached model.
webdb.txp (90.6 KB)