Hello,
I'm tasked with making a database of an archive of videos.
Now here's the bit I'm having trouble with. On each video set are a few live performances from three or four bands. Each band has several songs in their sets and each video was filmed at an event. So there can be several videos for one event and an artist can have played at one or more event.
Is this making sense?
Anyway, attached is the database relationship table I've made so far. I'm pretty rusty with access.
What I eventually want to be able to do is search for an artist and the database will tell me what evemts they've played at and what the code is on the tape so I can find it in the physical world.
Or I want to search by year and see who played at that year's event and what songs they played.
Is my relationship table looking right? When I try to make a form to fill in all the information, some fields won't let me type, when I go into table mode it says I need related data. I haven't got to grips with making forms without using the wizard.
Thanks so much in advance by the way. I'm really rusty with this program and could use with some help.
i55.tinypic.com/2j46gly.jpg
Henners
I'm tasked with making a database of an archive of videos.
Now here's the bit I'm having trouble with. On each video set are a few live performances from three or four bands. Each band has several songs in their sets and each video was filmed at an event. So there can be several videos for one event and an artist can have played at one or more event.
Is this making sense?
Anyway, attached is the database relationship table I've made so far. I'm pretty rusty with access.
What I eventually want to be able to do is search for an artist and the database will tell me what evemts they've played at and what the code is on the tape so I can find it in the physical world.
Or I want to search by year and see who played at that year's event and what songs they played.
Is my relationship table looking right? When I try to make a form to fill in all the information, some fields won't let me type, when I go into table mode it says I need related data. I haven't got to grips with making forms without using the wizard.
Thanks so much in advance by the way. I'm really rusty with this program and could use with some help.
i55.tinypic.com/2j46gly.jpg
Henners