Jump to content

Field Validation from more than one Field

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

Recommended Posts

Database Background: I work in the semiconductor industry and I am trying to track which wafers are processed with which masks. Not to delve into the technical side too much but we manufacture many different wafer types and each wafer type has it's own mask type. In addition we have thousands of each mask type. Currently I have built two databases; Database 1 tracks the mask inventory, and Database 2 tracks the wafer processing. They are relational so that in Database 2 when I enter the mask number it pulls in other relavent information about that mask. Also, when the mask number is enetered into Database 2, I am validating the mask number field against the mask inventory in Database 1 to make sure that it is a valid mask number.

Problem: When a mask number is assigned to a wafer in Database 1, I would like to validate multiple fields of data before the database allows the entry. Specifically I want to validate that it is a valid wafer number, that the mask type matches the wafer type, and that the mask be in an available state (the mask state can be either Available, Engineering Hold, or Scrapped)

Link to comment
Share on other sites

I guess you want to set the validation by calculation something like:

>SmallestWaferNumber and <LargestWaferNumber and MaskType = WaferType and MaskState = "Available" or MaskState = "Engineering Hold' or MaskState = "Scrapped"

Chaeck Strict and isnert your own custom message.

You can of course use fields from the related database for the values.

Link to comment
Share on other sites

This topic is 7841 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

  • Create New...

Important Information

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