Creating queries and forms so data can be manually updated

[captainquigers]

I have a table that contains a single field.

The data in the field is a contact salutation for an account holder, e.g.

Mr Bob Smith & Mrs Julie Smith

I need to create a new table with this information normalised e.g.

Original Data
Title1
First Name1
Surname1
Title2
First Name2
Surname2

The majority of this data will be normalised using various coded rules. As the data can get quite complicated I also have to create a form so users can manually update the data.

Presumably, I would need the following;

A flag that identifies which records have been updated and which need to be corrected.
A query to select a single record for the user to correct.
A form to display the original record and for the user to input the new data into.

I also need this to work on a network in a multi user environment but I can't seem to get the record locking to work. When a record is in use on one PC it can also be accessed by another.

Any help would be gratefully appreciated. Also if you have any links to tutorials or guidelines on how to do this I would be happy to read through them to get a solution.

Cheers,

Captain.