Copying data from multiple fields on one form, to another form.

[Jonathan]

I've seen this subject here in a similar fashion, but not in a fashion
that can easily be accomplished for my purpose.

Simply put, I have a form, I have about 2 dozen fields on this form,
that I may need to move to the next record. For example:

first_name
last_name
address
address_2
city
state
zip
phone_home

etc. I will have specific information to track - like how many items
I have loaned out to a particular person. So, if they have 6 items, I
don't want to have to retype the same information six times.

For some reason, I have been asked to duplicate that information,
rather than have six options for items. Hence, all this data will
need to be duplicated to another record, like the table example below

john smith 35 main street anytown ma 55555 camera nikon
D90
john smith 35 main street anytown ma 55555 flash generic
john smith 35 main street anytown ma 55555 tripod Bogen
john smith 35 main street anytown ma 55555 battery Duracell
lithium

Hope I didn't give too much information, but enough for any help.

Thanx in advance for all those that help me with this project. I'm
volunteering my time for a non-profit organization, so I don't have
the budget to look outside the web.

Cheers,

Jonathan

[Pieter Linden]

jo***********@lycos.com (Jonathan) wrote in message news:<32**************************@posting.google. com>...

I've seen this subject here in a similar fashion, but not in a fashion
that can easily be accomplished for my purpose.

Simply put, I have a form, I have about 2 dozen fields on this form,
that I may need to move to the next record. For example:

first_name
last_name
address
address_2
city
state
zip
phone_home

etc. I will have specific information to track - like how many items
I have loaned out to a particular person. So, if they have 6 items, I
don't want to have to retype the same information six times.

For some reason, I have been asked to duplicate that information,
rather than have six options for items. Hence, all this data will
need to be duplicated to another record, like the table example below

john smith 35 main street anytown ma 55555 camera nikon
D90
john smith 35 main street anytown ma 55555 flash generic
john smith 35 main street anytown ma 55555 tripod Bogen
john smith 35 main street anytown ma 55555 battery Duracell
lithium

Hope I didn't give too much information, but enough for any help.

Thanx in advance for all those that help me with this project. I'm
volunteering my time for a non-profit organization, so I don't have
the budget to look outside the web.

Cheers,

Jonathan

Normalize, and this is a cake walk.
CREATE TABLE Person(
PersonID AutoIncrement,
Firstname Text(25) Not Null,
LastName Text(25) Not Null,
Address Text(50) Not Null,
City Text(25) Not Null,
State Text(2) Not Null,
ZipCode Text(5) Not null)

CREATE TABLE Borrows(
PersonID Long,
ItemID Long,
IssueDate Date,
ReturnDate Date)

CREATE TABLE Item(
ItemID AutoIncrement,
Description Text(50) NOT NULL)

Then it's just
Person---(1,M)--Borrows--(M,1)--Item