| | |
|
|
|
Duplicate query |
|---|
| message from =?Utf-8?B?SmVubmlmZXIgTGVlbg==?= on 10 May 2004 |
Hi,
I used a Find duplicate query to find students with the same address. Is there any way to assign the students with the same address a unique family number. So in other words, once it finds the students with a duplicate address could I run a script that would give them a unique family number
Thanks
Jennifer
|
| Armen Stein replied to =?Utf-8?B?SmVubmlmZXIgTGVlbg==?= on 10 May 2004 |
Hi Jennifer,
This would take some VBA code to do; I don't know of a simple script
that would accomplish it. Anyway, you would still end up with duplicate
address data, which is not what you want in a relational database.
The proper way to do this is to have a Household or Family table, which
contains the address. Then, each Student can belong to that Household.
|
|
Archived message: Duplicate query (Microsoft Access Error Message)
