dynamictiger
Registered User.
- Local time
- Today, 11:42
- Joined
- Feb 3, 2002
- Messages
- 270
I am developing an application for tracking swimming pool data.
The logic has split the client details into two parts. The client personnel data and the pool address data, as the client can move, but the pool does not.
In some cases the client can have more than one pool, and this structure copes with this.
However, in some cases the mailing address for the client could be another address altogether, for example a real estate firm as the landlord.
For this reason I am thinking of adding a mailing address table. However, I am not convinced I need it and less convinced I can sort it out to derive the correct address from the two tables for the clients who have a mailing address.
Anyone had any experience with something similar?
The logic has split the client details into two parts. The client personnel data and the pool address data, as the client can move, but the pool does not.
In some cases the client can have more than one pool, and this structure copes with this.
However, in some cases the mailing address for the client could be another address altogether, for example a real estate firm as the landlord.
For this reason I am thinking of adding a mailing address table. However, I am not convinced I need it and less convinced I can sort it out to derive the correct address from the two tables for the clients who have a mailing address.
Anyone had any experience with something similar?