The Mudcat Café TM
Thread #66142   Message #1095335
Posted By: GUEST,Jon
18-Jan-04 - 02:36 AM
Thread Name: Tech: Set List Software
Subject: RE: Tech: Set List Software
Depending on how much material you have and how often you may use the same set, I'd either take Susan's Excel route or a MS Access route.

With the Acess route, what you could do is have 2 tables, 1 called song and one called set.

Song could contain SongID (a reference number), SongTitle and any optionaly, other useful information as suggested by Susan.

Set could contain SetID, SetTitle, SongID (to link with the info in the Song table) and SortOrder (To set the order of a song within a set).

It would take more work to set it up and a little time would be required to make it user friendly but once done, you would have records of past sets that you may like to call up again as well as modify qutie easily if say you just wanted to change one song or the running order.

Jon