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
<*> 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/
