By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
425,940 Members | 614 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 425,940 IT Pros & Developers. It's quick & easy.

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

P: n/a
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
Nov 12 '05 #1
Share this Question
Share on Google+
1 Reply


P: n/a
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
Nov 12 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.