Been a while since I did this & can't remember how.
tblInvoice
InvoiceID PK
VendorID FK
AddressID FK
etc.
tblVendor
VendorID PK
VendorName
etc.
tblAddress
AddressID PK
AddressLine1
AddressLine2
City
State
Country
Zipcode
frmMain contains cboVendor and cboAddress. What I want to do is to be able
to set up a new invoice, select a VendorName using cboVendor, then select an
address from one of the available addresses for the vendor selected by
cboVendor using cboAddress. tblInvoice will save the Vendor and Address
selected. I can't remember how to code the forms Access 2000.
Daniel - 13 Feb 2007 12:59 GMT
You want to base one combo box on the value of another. take a look at the
microsoft tutorial
http://office.microsoft.com/en-us/access/HA011730581033.aspx
Daniel
> Been a while since I did this & can't remember how.
>
[quoted text clipped - 23 lines]
> cboVendor using cboAddress. tblInvoice will save the Vendor and Address
> selected. I can't remember how to code the forms Access 2000.