进行中

Create an Unique ID for clients in Access

I need a "Unique ID" created for each client added to the database. The Unique ID should be stored in the "Client Intake (Ind)" table in the "UniqueID field".

When you open the database you'll see a screen with one button "Intake". This button will take you to the main intake screen where you can access the forms that users will use to add info (under step 1) and where users can edit info (under step 2)

Part One - User Adds a client.

The unique ID should contain

1. The first character of the first name

2. The First and Third Character from the last name

3. A gender representaiton (M=Male, F=Female)

4. All eight characters from the date of birth (i.e. 01/10/1975 should be 01101975)

5. A "Soundex" of alpha-numeric characters based on the way the client's name sounds. For moreinformation on soundex use <[url removed, login to view]>.

EXAMPLE

Client: Joshua Jones

Date of Birth: 10/11/1960

Gender: Male

UNIQUE ID = jjn1011960j200j520

Part Two - User edits a client

When a user edits any of these 4 fields, the following process should occur to save the old unique ID and create a new one.

1. The "Unique ID" field should be copied to the "OldUniqueID" field in the "Client Intake (Ind)" table.

2. The field "Unique ID Extract" should be "unchecked" and the "DateUniqueExtract" should be cleared, if their not blank.

3. The Unique ID should be recreated based on the update(s) and stored in the "Unique ID" field.

I prefer a coder that is open to another project using this same database if this bid is completed according to specs and in a timely mannor.

## Deliverables

1) Complete and fully-functional working program(s) in executable form as well as complete source code of all work done.

3) All deliverables will be considered "work made for hire" under U.S. Copyright law. Buyer will receive exclusive and complete copyrights to all work purchased. (No GPL, GNU, 3rd party components, etc. unless all copyright ramifications are explained AND AGREED TO by the buyer on the site per the coder's Seller Legal Agreement).

## Platform

Windows XP, Microsoft Access 2000-2003

技能: PHP

查看更多: work for wikipedia, project intake form, party characters for hire, male for hire, hire wikipedia, hire microsoft access, for hire wikipedia, en save, date for hire, create an site, code for update in php, character for hire, alpha source, alpha hire, alpha coder, access for hire, characters for hire, wikipedia edit, unique user, joshua, in process access, create a character, access 2000 database, forms update example, update form access

About the Employer:
( 43 reviews ) Phoenix, United States

项目ID: #3136612

已悬赏给:

maramayvw

See private message.

$29.75 USD 在7天内
(97条评论)
5.6

7名威客为此工作的平均竞标价是$52

brightsolnslx

See private message.

$42.5 USD 在7天内
(303条评论)
6.4
erikhumala

See private message.

$42.5 USD 在7天内
(94条评论)
4.8
rkiranjosh

See private message.

$42.5 USD 在7天内
(38条评论)
4.4
simmy

See private message.

$59.5 USD 在7天内
(20条评论)
4.2
pickyguide

See private message.

$127.5 USD 在7天内
(29条评论)
4.0
vw1730191vw

See private message.

$17 USD 在7天内
(0条评论)
0.0