Re: Add values to a text field
- From: "Allen Browne" <AllenBrowne@xxxxxxxxxxxxxx>
- Date: Sat, 29 Jul 2006 23:07:13 +0800
Lana, this is the wrong design.
If several people can be in a distribution, you need another table, with a
one-to-many relation to the first table.
That's how relational databases work.
If it's a new concept for you, see:
Relationships between Tables (School Grades example)
at:
http://allenbrowne.com/casu-06.html
--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.
"Lana" <Lana@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:B2FCEC4D-4085-4F16-8285-8B3BB5271CC1@xxxxxxxxxxxxxxxx
Hi all,
I got a text field called "Distribution" where i input names of
personnel -
usually it is 1-3 persons out of 5-6 from a list, but sometimes it could
be
somebody who is not in list.
I would like to introduce 5-6 unbound check-boxes on my form, clicking
each
of them would add up a name into the text field. (i want to be able as
well
to add something manually)
I know how to replace a value of a text field with other value, but i want
to be able to ADD to existing value.
Can somebody help me with a script?
Thank you.
Lana
.
- Prev by Date: Re: dlookup
- Next by Date: Re: Add values to a text field
- Previous by thread: Re: dlookup
- Next by thread: Re: Add values to a text field
- Index(es):
Relevant Pages
|
