Hi

Sorry, this could be another silly question, but maybe not

I have two tables - projects and images

There are multiple images for each project, but there are never more than one project for each image so a simple 1:M relation can exist.

My question is relating to the images. I wanted to have 'default' image for each project, but if I create a default field in the images table, it seems to only allow one default in the entire table, not one default per project.

Anyone got any suggestions?

Yes, you can do that.

In the wizard, there is a "Group By" parameter. Just drop the Project FK, then the default will apply only for that group.
Same as ordering wizard.