Jump to content

help with multiple relating records


djsolo
 Share

This topic is 5735 days old. Please don't post here. Open a new topic instead.

Recommended Posts

  • Newbies

I'm setting up a database to track visual effect shots for a short film.

The MAIN table has the shot number and a field for the approved version.

The VERSION table has fields for serial number, shot number, version number, and a field for approved/not approved. The tables are linked by shot number.

I only want the "approved" version number from the VERSION table to appear in the "approved version" field on the MAIN table.

There must be a clever way to do this that I just can't think of!

Link to comment
Share on other sites

You could define a calculation field in Versions =

Case ( Approved ; ShotID )

then define a new relationship based on this field.

However, what you describe allows for more than one version to be approved. A better way would be to select the version by a script that sets an ApprovedVersionID field (in the Shots table) to the selected VersionID value.

Link to comment
Share on other sites

This topic is 5735 days old. Please don't post here. Open a new topic instead.

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
 Share

×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.