Multiple entries in one field

[Tarvos{k}]

Greetings all,

I am working on a new db that will be used as an address book. I wanted to
have a field named Child, but I wanted to allow for the possibilites of more
than one child for the entry. Can anyone suggest something other than
multiple child fields.

Tarvos{k}

[Rick Brandt]

"Tarvos{k}" <ta****@chartermi.net> wrote in message
news:yT****************@fe04.lga...

Greetings all,

I am working on a new db that will be used as an address book. I wanted to
have a field named Child, but I wanted to allow for the possibilites of more
than one child for the entry. Can anyone suggest something other than
multiple child fields.

Tarvos{k}

The proper method of course is multiple TABLES. You never store more than one
value in a single field. Children should be a separate table with a one-to-many
relationship between your existing table and the children table.
--
I don't check the Email account attached
to this message. Send instead to...
RBrandt at Hunter dot com