Can't add related fields without subform/vlookup?

[HLCruz via AccessMonster.com]

I've read the message threads under this topic and I'm shocked! I have a
simple form with basic mailing information; I'd like use the address and city
fields from my related ZIPS table on my form so that they populate with the
correct data from the related zip codes. VLookup? Subforms? This is
rediculous - someone please tell me that such a simple task can be done with
out all this run around...

 

[HLCruz via AccessMonster.com]

Create a query with fields from all related tables and use query as record
source for form ...
Sorry for the stupid question - in FileMaker this process didn't require so
many steps ...