navigation

[indhu]

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,f ell down, jumping, running) shot comes visually as images.
scene1-walking -shot 1(textfield)-sliping(picture box),

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.

[willakawill]

You are describing a database schema here.
Each row from the shot table has a foreign field that links it to a primary key in the scene table
Each row from the scene table has a foreign field that links it to a primary key in the sequence table