Hi Guys,
My company maintains properties, some of which ARE the address of the billing company, some of which ARE NOT... I've normalized my database by creating a seperate table for addresses so as to eliminate the redundancy of typing the address in twice in the case of the maintaned property and billing address being the same.
Relationships Established In reference to addreses:
Customers - (One to Many) - Orders - (One to Many) - OrderDetails, etc etc.
Previously an address was entered manually under both tblCustomers and tblOrders; hence, the redundancy issue. Now I have a tlbAddresses, each with an autonumber, and in tblCustomers and tblOrders I have an "Address" field set to Long Integer, and the realationships have been set.
In my forms: NewCustomer and NewOrder, I'd like to have the ability to select an existing address, or type a new one in if needed.
A list box would allow me to SELECT an address, but how do I add a new one... I'm having issues linking a subform.
Is this even the best way to do this? Should I just allow for the redundancy...
OR is there a way to script a 'check box' to update tblOrder address info re "Same As Billing Address".
Thanks Guys
My company maintains properties, some of which ARE the address of the billing company, some of which ARE NOT... I've normalized my database by creating a seperate table for addresses so as to eliminate the redundancy of typing the address in twice in the case of the maintaned property and billing address being the same.
Relationships Established In reference to addreses:
Customers - (One to Many) - Orders - (One to Many) - OrderDetails, etc etc.
Previously an address was entered manually under both tblCustomers and tblOrders; hence, the redundancy issue. Now I have a tlbAddresses, each with an autonumber, and in tblCustomers and tblOrders I have an "Address" field set to Long Integer, and the realationships have been set.
In my forms: NewCustomer and NewOrder, I'd like to have the ability to select an existing address, or type a new one in if needed.
A list box would allow me to SELECT an address, but how do I add a new one... I'm having issues linking a subform.
Is this even the best way to do this? Should I just allow for the redundancy...
OR is there a way to script a 'check box' to update tblOrder address info re "Same As Billing Address".
Thanks Guys
