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

Multiple entries in one field

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


P: n/a
"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

Nov 13 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.