473,327 Members | 1,952 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,327 software developers and data experts.

Duplicate Addresses

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
Nov 13 '05 #1
1 1280
In the AfterUpdate event of each field for the ContactAddress enter the
following code.

If IsNull(Me!FromAddress) Then
Me!FromAddress = Me!ContactAddress
End If

Change the FromAddress and the ContactAddress with the names of the fields
on the form. If you have a City field use
If IsNull(Me!FromCity) Then
Me!FromCity = Me!ContactCity
End If

After you enter anything in the contact address field and the from address
has no value, the from address field will be filled automatically with the
value of the contact address.

Jeff
"Richard Jenkins" <go*****@telex.freeserve.co.uk> wrote in message
news:4d**************************@posting.google.c om...
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

Nov 13 '05 #2

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

4
by: Robert | last post by:
Im a beginner in PHP and Im having a problem with this code. Im trying to remove duplicate elements from an array created via $_GET. I want users to be able to click on a link which sends an email...
44
by: Xah Lee | last post by:
here's a large exercise that uses what we built before. suppose you have tens of thousands of files in various directories. Some of these files are identical, but you don't know which ones are...
1
by: JStrummer | last post by:
I just put together a PHP mailing list sign-up page that posts to a mySQL DB. The PHP script prevents INSERTs when the email address is already located in the database. Problem: I need to import...
9
by: Catherine Jo Morgan | last post by:
Can I set it up so that a certain combination of fields can't contain the same entries, on another record? e.g. a combination of FirstName/LastName/address? Or FirstName/LastName/phone? Or...
8
by: Ray | last post by:
I have a data input form and need to automatically duplicate the existing record as a new record by clicking a button. The main purpose to duplicate the record is that the new record is very...
16
by: Jay Douglas | last post by:
Does anybody know the odds of generating a duplicate guid? -- Jay Douglas http://jaydouglas.com
4
by: Dabbler | last post by:
I'm trying to setup a email info config section like: <contactForm> <email> <add key="toaddress" value="he@hishost.com;" /> <add key="toaddress" value="she@herhost.com;" /> <add key="toaddress"...
10
by: Backwards | last post by:
Hello all, I'll start by explaining what my app does so not to confuss you when i ask my question. ☺ I have a VB.Net 2.0 app that starts a process (process.start ...) and passes a prameter...
4
by: HLCruz via AccessMonster.com | last post by:
I am working with a database that has client information separated in to 4 related tables - tFolder, tAddress, tEmail, tPhone number. In addition there are related tables tGifts and tCalls. The...
3
by: pbrown | last post by:
Hi. I'm a relatively new Access 2000 user, and I've got a problem thats got me stumped. I have a table of street addresses and property numbers that looks something like this: Name, Location,...
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
1
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
1
by: Shællîpôpï 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
0
by: af34tf | last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome former...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.