null value or zero string

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi,
I have a problem with creating a control that could lookup and indetify a
missing coresponding record from one table. I have one table that has a
subtable, i want to create a control that will notify me (user) of a missing
record in a subtable. I tried with iifnull function but it does not work, it
works only if all required fields are in one table, but, if i lookup a value
in another table i dont get any result for the records that are missing in
the subtable. Where did i go wrong?
 
Hi,
I have a problem with creating a control that could lookup and indetify a
missing coresponding record from one table. I have one table that has a
subtable, i want to create a control that will notify me (user) of a missing
record in a subtable. I tried with iifnull function but it does not work, it
works only if all required fields are in one table, but, if i lookup a value
in another table i dont get any result for the records that are missing in
the subtable. Where did i go wrong?
Click to expand...

Hi there -

I think that you have had no responses because we are all confused.
There is no such thing as a "subtable." There is a "sub form."


You need to go back to the basics of table design. Is it that your two
tables have a one-to-many relationship and you are looking for the
orphan records?

Your question is too far off to answer. Sorry

Diane
 
Back
Top