A
Ann Scharpf
I am setting up a little database (in Access 2003) for our java programmers.
They want to have two primary tables:
MainCode
ProgramName (short name)
ProgramCode (path & java file name)
MainUses (path & java file name called by ProgramCode - MANY)
ExtendedCode
ExtCode (path & java filename)
ExtUses (path & java file name called by ExtCode - MANY)
There should be a validation on the ExtCode field. The user should not be
able to enter a value that does not exist in one of two places:
MainCode.MainUses
ExtendedCode.ExtUses
(I.e. cannot set up program X to call other programs until program X has
been called iteself by either the primary program or by one of the secondary
programs.)
Does this make sense? How would I go about a checking field in the table
that I'm adding a record to as well as a field in another table?
As always, thanks very much for your help.
They want to have two primary tables:
MainCode
ProgramName (short name)
ProgramCode (path & java file name)
MainUses (path & java file name called by ProgramCode - MANY)
ExtendedCode
ExtCode (path & java filename)
ExtUses (path & java file name called by ExtCode - MANY)
There should be a validation on the ExtCode field. The user should not be
able to enter a value that does not exist in one of two places:
MainCode.MainUses
ExtendedCode.ExtUses
(I.e. cannot set up program X to call other programs until program X has
been called iteself by either the primary program or by one of the secondary
programs.)
Does this make sense? How would I go about a checking field in the table
that I'm adding a record to as well as a field in another table?
As always, thanks very much for your help.