The design of your table is incorrect. If you have data like this, you have a
one-to-many relationship in that field where you want to have more than one line
of data. You need one table for the main part of your existing record and a
second table for the data you want to have more than one line of data in your
record. An example would be parents and children. You need one table to record
the parents which would look like:
TblParents
ParentsID
FatherFirstName
FatherLastName
MotherFirstName
MotherLastName
etc
and you need another table to record the children which would look like:
TblChild
ChildID
ParentsID
ChildFirstName
ChildLastName
ChildSex
etc
So for a set of parents, you have one parent record with the possibility of
multiple child records. A relationship is created between ParentsID in both
tables. ParentsID in TblParents is referred to as the primary key in the
relationship and ParentsID in TblChild is referred to as the foreign key in the
relationship.
--
PC Datasheet
Your Resource For Help With Access, Excel And Word Applications
re******@pcdatasheet.com www.pcdatasheet.com
"Abbey Krystowiak" <kr**************@basco.com> wrote in message
news:41**********************@news.newsgroups.ws.. .
I want to have one row of information in a table, but in one of the
fields I want to have more lines of data without creating a new row of
everything being the same except one field. Can you do that?
*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!