Updating a database with ASP

[Mike]

I have a functioning Access 2002 Dbase. Until
now I have only needed to write new records.

Now I need to write to a specific field within
an existing record. For example:

I have a table (CustomerInformation) that
contains Name, Address, Phone, etc...

I have a second table (CustomerDates) that
contains their Name, for the Relationship
between tables, and has many different
date fields in it. As a customer reaches a
milestone I need to have a date written to the
appropriate field using an online form.

I need to tell the form the customers name and
have it only write the information pertaining to
that customer. I do not want it to write their name
again causing duplicates.

I hope that I explained myself.

Mikeal

 

[Jim Buyens]

First, are these tables 1:1? In other words, for each
CustomerInformation record, is there:

o Always one CustomerDates record?
o Sometimes no CustomerDates record, and sometimes one?
o Zero to many CustomerDates records?

Second, are you comfortable writing ASP or ASP.NET
program code? If so, which?

Jim Buyens
Microsoft FrontPage MVP
(e-mail address removed)
http://www.interlacken.com
Author of:
*------------------------------------------------------*
|\----------------------------------------------------/|
|| Microsoft Office FrontPage 2003 Inside Out ||
|| Microsoft FrontPage Version 2002 Inside Out ||
|| Web Database Development Step by Step .NET Edition ||
|| Troubleshooting Microsoft FrontPage 2002 ||
|| Faster Smarter Beginning Programming ||
|| (All from Microsoft Press) ||
|/----------------------------------------------------\|
*------------------------------------------------------*

 

[Mike]

Jim,

This is a 1:1.

I have been using ASP for a couple of months.
I am still learning but am fairly comfortable.

Mikeal