I know that you specify sort order in the relationship setup of the database but I have a specific problem, that may mean that I do not or can not use a portal.

I have created a media database of several video files, with thumbnails in the records for visual identification.

I have now created another database to create playlists of the media files. I need to be able to display certain media files through a portal (which I have completed using a repeating playlist ID field in the media database). BUT I need to be able to re-order the displayed order of the media files in the database.

Anyone got any bright ideas?

Joel

Get rid of the repeating field in your playlist file. Create a related playlist items file which will have these 3 fields: Playlist number, video ID, and Playlist order. Then in the relationship definition you can sort by the playlist order field so that in your portal, the videos show up in the order to be played.