Entry calculations based on other entries - Learning this software

[RowN]

Hi to anyone that can help,

So I am creating databases that are linked. I'm building this for some video/film editing work

I have two database one for SEQUENCES one for SCENES

in the SEQUENCES database I have fields for SEQUENCE #, SCENE FROM and SCENE TO (plus other parameters that are irrelevant).

in the SCENE database I have SCENE #, SEQUENCE #, SCENE FROM and SCENE TO.

What I want to be able to do is fill out the SEQUENCE list first with all the information then when I go into the SCENE database and enter SCENE # - for example scene 7, it will automatically enter SEQUENCE#, SCENE FROM and SCENE TO into the other fields, eg. SEQUENCE 4, FROM 5 - TO 9.

Does that make sense? If anyone can help with the script I would be most appreciative.

thanks,

Rowan

[comment]

Does that make sense?

Not really, I am afraid. Is sequence a group of scenes - or is it the other way around? And what does SCENE FROM and SCENE TO mean?

[RowN]

Hi,

The sequence is a group of scene that start at any particular scene and end at another.

For instance:

Sequence 1 might consist of scenes 1 to 5 (SCENE FROM = 1, SCENE TO = 5).

Does that help?

Thanks for replying. I guess it's a complicated question.

Cheers,

Ro

[comment]

I guess it's a complicated question.

I am not sure of that. It's just not clear why you have all those fields in the Scenes table. If the scenes included in a sequence are determined by the SCENE FROM and SCENE TO fields in the Sequences table, then all you need in the Scenes table is the Scene #.

Note that your method allows a scene to be included in more than one sequence.

[RowN]

Thanks. I think I need to delve deeper into the program and try to figure it out.

Can you recommend any tutorials for scripts?

[imoree]

Before you do any scripts, you need to understand the relationship of data you are trying to accomplish;

IE>> " I work for a company that needs to be able to edit scenes that start at a particular

frame and end at another frame. There will be users that can blah bla "

get all the nouns and create an ERD (Entity relational diagram) - YOu need to find the parent table and other children tables that "Obey" the parent. When you have a many scenes to many edits - then you need to create a JOIN TABLE> THEre are tons of tutorials on youtube, lynda, vtc..

-i