Design

[Bernadette]

I have a data base with among others, two fields
called "Lname of Householder1" and "Lname of
Householder2".

When the Lname of Householder1 is entered, I would like
this field to be carried to the "Lname of Householder2"
if there is in fact a Householder2, by using a Lookup or
something, but also want to be able to type in a
different name for Householder2 where there is a defacto
relationship for example.
Any help would be appreciated

 

[TC]

Please don't multi-post! This will seriously test the patience of
newgroup regulars.

Instead, CROSS-post. Look up these terms on the internet if you're not
sure what they mean.

HTH,
TC