Hi,
I'm designing a database for a small removal company.
The information we need includes the customer's contact address, the
address they're moving from and the address they're moving to.
I currently have the contact address in the Customers table, the from
and to addresses in seperate tables (FromAddresses & ToAddresses) and
a Moves table linking the three together.
One problem is that the contact address is usually the same as the
from address, but I have to allow for the fact that they might be
different. This means that most of the time we will be entering the
same information twice, which is something I'd like to avoid.
Can someone suggest a good way to handle this situation?
Thanks,
Richard