Null values from different tables

  • Thread starter Thread starter Carrie
  • Start date Start date
C

Carrie

Hi, I have a database with several tables. The users fill
in a variety of forms(these are applications). They
always fill in a Sched1 and will then either fill in a
Sched2 or a Sched3. Because these forms contain so much
data, each one relates to a couple of tables. (ie. Sched2
contains info in Tables Sched2P1 and Sched2P2 - and the
Main Table for RecNo, Name etc.) After all their apps
have been approved they fill out a Close Form which they
print for their files, containing some key info from the
Main Table.

I have now learned that they need the Category field on
the Close Form, which is contained in Table Sched2P1 or
Sched3P1 (depending on the one they need to fill out).

Right now I have got the Close Form going to the Main
Table with no query but, I am sure I need to change that.
I want the Close Form to have a Category Field that will
fill in one if the other is blank but, I am having trouble
figuring out how to write the query to accomplish this.

Thanks for your help!
 
think your design is going to scare off most people from responding. Are you
sure you really have 255+ fields that are totally dependant upon the primary
key??
ven so, to answer the crux question "I want the Close Form to have a
Category Field that will fill in one if the other is blank"
You can detect the contents of another table using a few functions such as
DLookup or DCount. This will then allow you conditionally add the value to
the Category field.

I
 
Back
Top