I need help with my database.
Im uploading my database and if you open frmCompanyDetails you will see what Im trying to do, I had some help through this forum and also privately from a member of UtterAccess. The problem is I am teaching myself access as I go along and it is difficult - but Im not going to let that stop me.
The main form of my database seems perfect at this stage and so is the subform for contacts - ideas for these areas of my database will be welcome.
But now I come to the ADDRESSES part of my form (its also a subform) and thats where I get stuck.
For any of my companies I will have at least 3 addresses. A physical address, a postal address and a delivery address.
Natrually the physical address will be a street address and the postal address and delivery address could be either a street address or a P.O. Box address.
A customer may also make a request that a certain address be delivered to - this needs to be kept on record since I may need to deliver to that address
There also maybe another physical addressagain.
I was thinking that a field (to be later placed on a form) needs to be created for every part of the address (i.e. The 4 lines of a usual address and only those relevant displayed. Difficult to describe since I want to separate the lines of each address and dont particularly want to display "empty" columns. The unheard of may happen - what if a certain address is 5 or 6 lines long, what do I do?
Examples of address (Physical)
123 Saxon Road, Heights, 7300 - 3 lines
1542 Plain Street, Bromley Manor, Johannesburg, 2456 - 4 lines
Office 2A, 15 Walker Avenue, Meadowfields. Apple Valley, 1246 - 5 lines
Example of postal address
P.O. Box 175, Cape Town, 8000
There also maybe another physical address - perhaps the company has another branch, also there maybe another postal address because the company may have another mailing address.
Now a delivery address and a postal address can be the same as the physical address, things could be delivered to a P.O. Box and a special delivery address could be specified which could be a physical address or a postal address.
I have been trying to rack my brain on how to do this in access but I cannot.