It is not a good idea to duplicate where information is stored, but rather have only one place and then reference to this.
You could have your combo box to select the company name and then use the company name to gather the information about the addresses from the companyInfo table. ----- Original Message ----- From: "ltportellar" <[EMAIL PROTECTED]> To: <[email protected]> Sent: Saturday, April 15, 2006 2:18 PM Subject: [ms_access] (unknown) > > 1. Table CompanyInfo has fields entitled (a) CompanyName (b) > Address1 (c)Address2 and they are populated already > 2. Table InvoiceInfo has identical blank fields entitled (a) > CompanyName (b)Address1 (c)Address2 > 3. To prepare some invoices need to populate table InvoiceInfo > and do so with a combo box by selecting the appropriate companyname > from the table CompanyInfo and the question here is how can I get the > corresponding Address1 and Address2 transferred automatically from > table companyinfo to table InvoiceInto based on the selection made for > Companyname > > Can it be done? If so, how? Thank you > > > > > > > > Yahoo! Groups Links > > > > > > > Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/ms_access/ <*> To unsubscribe from this group, send an email to: [EMAIL PROTECTED] <*> Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
