How to edit a raw table, showing a foreign key value as reference

Question

I have a simple table for a gallery. There are many galleries, each containing images - which may belong to multiple galleries.

Basically this is a 'cross table' with a sort order within that gallery.

CREATE TABLE [dbo].[GalleryXGalleryImage](
    [GalleryId] [int] NOT NULL,
    [GalleryImageId] [int] NOT NULL,
    [SortOrder] [int] NOT NULL CONSTRAINT [DF_GalleryXGalleryImage_SortOrder]  DEFAULT ((1)),
 CONSTRAINT [PK_GalleryXGalleryImage] PRIMARY KEY CLUSTERED 
(
    [GalleryId] ASC,
    [GalleryImageId] ASC
)

I need to edit this table within the database (no time to create a UI) but I need visual cues about which images are which to be able to put them in the correct order.

If I show WHERE GalleryId=13 and do a cross join on GalleryImages for GalleryId then I see a list, but of course I cannot actually edit this table because of the cross join.

I need to find a way to edit the GalleryXGalleryImage table but still see the names of each image. If this can't be done in enterprise manager (by somehow telling it to ignore the image name column) then I'm sure there must be some other tool to do this.

I'd rather not write a UI, or try to cut data back and forth from excel.

Edit: I actually meant inner join. I said 'cross' by mistake becasue i'd already mentioned cross table.

Answer 1

Your SortOrder column belongs on the Gallery table, not the GalleryXGalleryImage table. It applies to a gallery and not to paritcular images within that gallery.