DJ CD Database Help

[ainsley_clark]

Hi There,
I am in the middle of building a CD Database for organisation of CD's. I have one table which contains, ID, Title, Artist and Genre.
I get a gig around once a month and they usually send me a huge list of what they want to be played.

What I want to be able to do, using a form, is to locate wether or not I have the track in the database already, and if I dont, add a track to the database.

Preferbley I would want access to compare the versions and then generate a list of what songs I dont have already..

Then I want the database to automatically to create a table (I think a table, maybe a query) of the playlist so I can print it of in a report.

I Hope this makes sense and im nto asking for to much!
Much appricated if you could help me....

 

[Tiro Cupidus]

It sounds like you should be able to import the request list into a table in your database, then use the Find Unmatched Query wizard (New Query) to walk you through getting the list you need. If you want the results to automatically go into your main table, you can change the query type to "Append".

 

[ainsley_clark]

Thankyou Tiro.
I was wondering if you could in any possible way, use a form to input the data so it becomes a bit more user friendly?

 

[DCrake]

Simple Software Solutions

You mention a list that is sent to you, how is it sent? electronically? and in what format?

Does the structure of the file match the structure of the table in your database?

Do you want to retain the incoming playlist or is it used a s a simple exercise to determine what you need to acquire?

CodeMaster:

 

[twoplustwo]

Hi Ainsley,

Writing a form based on a query or table to input the data (or edit/delete etc.) isn't too hard (the wizards aren't bad when you're starting out).

We can help you out more if you answer Mr. Crake's questions

 

[ainsley_clark]

Hi everybody...
The playlist is sent to me electronically, containing the artist and title field, however it most probably will be written in word. I can seperate theese two field easily.
The structure of the file kind of resembles the database. The fileo nly contains two fields where has my main table contains around 5 or 6..
I would like the database to tell me what songs I dont have in the database (i.e songs I need to get) and then when I click a macro saying download complete or something, it will show a form where I can make the changes to the fields in the main table (genre, bpm etc..) and then when I click import it will import all this modified data into the main table.
It should also generate a report of what songs I need to download.
Thanks very much for your help!
Again hope im not asking for too much...

 

[DCrake]

Simple Software Solutions

What happens if there is a variation on the spelling, wording, etc. with the artiste or song? You may end up with duplicates. Therefore you need to be able to eyeball the mismatches prior to adding them to your database. Also what happens if you have a copy of a song but not by the requested artiste?

I am forever the pessamist and always look for "what ifs" before I decide on the course of action.

David

 

[ainsley_clark]

I will check the spelling and wording before the data is imported into the database so I can avoid duplicates.
Whilist doing so I will change the title if the song if there is copy, for example having (remix) in brackets or (artist remix)..

 

[ainsley_clark]

Any Ideas???...

 

[ainsley_clark]

Please help!