hi all
i am doing a project in vb 6.0 and ms access 2003
tables- story, shot
forms: project, shot, tracker
project has general info of proj(story table), shot has some inputs of scene images (shot table) but my problem come only retrieving data from backend. see, 1 sequence has many scene. one scene has many shots.(problem comes here) i don't know how to tackle that.
for eg. sequence(road bg), scene(walking), shots(sliping,fell down, jumping, running) shot comes visually as images.
scene1-walking -shot 1(textfield)-sliping(picturebox),
when i click sequence,it shld display scene(1) total shots(20), nagivation of shots will display pictures.
help me out to solve this. this might be simple but now am confused totally.