467,146 Members | 1,030 Online
Bytes | Developer Community
Ask Question

Home New Posts Topics Members FAQ

Post your question to a community of 467,146 developers. It's quick & easy.

Multiple Entries per field


Does anyone know if I can have a field in a row where I can add two
lines of info without adding a whole new line?
and then there would be a drop down menu?

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!
Nov 13 '05 #1
  • viewed: 4610
Share:
4 Replies
Abbey Krystowiak wrote:
Does anyone know if I can have a field in a row where I can add two
lines of info without adding a whole new line?
and then there would be a drop down menu?

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!


Not sure what you're asking here.

If you require more than one line of text in a textbox then yes, the
underlying column in the table should be sufficiantly large to hold the
text (either text or memo type) and a form's textbox properties can be
tweaked to allow multi line entry.

If OTOH you are suggesting as the subject line suggests then that's a
bad idea anyway, the columns should be atomic, i.e. hold one item of data.

If you're talking about a combo box (drop down list) then you can use
them but you cannot put multiple lines into them, they're for selecting
one of multiple values, the values themselves coming from a different
source than the table it's bound to.

--
Error reading sig - A)bort R)etry I)nfluence with large hammer
Nov 13 '05 #2
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!
Nov 13 '05 #3
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!

Nov 13 '05 #4
When connecting the tables, as I did, how can I then incorporate the
infomation that is connected (ex. child ID) into the parent's info table
when I want to create and run a query.

Ultimately what I need to be able to do is create a query for me and
others to use to search for information in the tables.

EX.
TABLE 1 fields:
Study Name
Date
Person Initiated
Study Done By
Type of Study
Product Category
Study Target
Study ID (primary key and autonumber)

TABLE 2 fields:
Keywords
Study ID

What I want to do is be able to narrow down to the Product Category, and
then be able to search by keyword.

The reason for my first request was that each "Study Name" has multiple
keywords. Hopefully this makes enough sense for someone to be able to
help me.


*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!
Nov 13 '05 #5

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

3 posts views Thread by Usenet | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.