If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Can't add related fields without subform/vlookup?
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... -- Message posted via AccessMonster.com http://www.accessmonster.com/Uwe/For...forms/200612/1 |
#2
|
|||
|
|||
Can't add related fields without subform/vlookup?
VLookup is Excel, Not Access.
You should not have the ZIPS table either on your form on in a subform. What is the layout of the ZIPS table? What is the Address info layout in your mailing information table? The idea here is to use the DLookup function to retrieve the correct Zip code; however, there has to be some field or fields in the mailing table to be able to match to a zip code. If you can define the fields in the two tables, then perhaps we can find a solution. "HLCruz via AccessMonster.com" wrote: 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... -- Message posted via AccessMonster.com http://www.accessmonster.com/Uwe/For...forms/200612/1 |
#3
|
|||
|
|||
Can't add related fields without subform/vlookup?
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 ... HLCruz wrote: 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... -- Message posted via AccessMonster.com http://www.accessmonster.com/Uwe/For...forms/200612/1 |
#4
|
|||
|
|||
Can't add related fields without subform/vlookup?
If you want some help, please provide the information I requested in my last
post. If you just want to vent, okay. "HLCruz via AccessMonster.com" wrote: 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 ... HLCruz wrote: 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... -- Message posted via AccessMonster.com http://www.accessmonster.com/Uwe/For...forms/200612/1 |
Thread Tools | |
Display Modes | |
|
|