'#name?' with 2 tables and 1 form

[Guest]

Hi,
I have the following two tables;
1) Houses {HouseID(Primary Key),Address, Postcode, Landlord}
2) Landlords {Landlord(Primary Key), Address, Postcode}

I have a form where I am trying to display the HouseID, Address, Postcode
and then Landlords!Landlord, Landlords!Address, Landlords!Postcode. I can see
the first three fields but the last three fields give the '#name? error. Any
ideas?

 

[Amy Blankenship]

Looks like you need a relationship between HouseID and LandlordID.

HTH;

Amy

 

[Guest]

I have created a relationship between Houses!Landlord and Landlords!Landlord
which should link the two tables togethor but I still cant see any fields
from the Landlords table.

 

[Amy Blankenship]

Are they the same data type? Do you have exactly one house per landlord?

-Amy

 

[Guest]

Yeah,they are the same data type. I have a 'many-1 relationship' (i.e. a
landlord can have 1 or more houses).

 

[Amy Blankenship]

Then what you want is a form for landlord with a subform for houses. You
can't handle it with just one form.

HTH;

Amy

 

[Guest]

Hi Amy,

My apologies in advance. I am very new to Access and VB. Can anyone point me
to a URL that details how to build a subform/form for the purposes of
updating two tables with one form?

Thanks,
--Paul