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! 4 5345
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
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!
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******@pcdata sheet.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!
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! This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics |
by: Jas |
last post by:
I want an ASP page with a dropdown and a simple button. Every time the user
chooses an item from the dropdown and clicks on the button i want that value
written below in list and allow user to select more.
Also how can these choices be saved somehow so tha when the user goes to the
next page the choices he made can be written to the database.
For example
The choices in the dropdown may be
|
by: Joe |
last post by:
Hey,
I'm going to give some background on my situation in case anyone can
point out a way around my problem altogether... for the problem
itself, please skip to the bottom of the post. thanks.
I've been having some problems with database performance... Several
threads are constantly attempting INSERTs of new records into a large
table - that is hundreds of thousands of records -large by my account
:-) The table has a VARCHAR field...
|
by: ccr |
last post by:
Please view in a text editor so that the columnar text lines up. I
used Terminal 9pt font to compose this post and copied/pasted to my
newsreader program.
I am writing in the hope that one of you Visual Basic experts may
provide a solution, or at least some insight, to the problem described
below. I am not a programmer, but am fairly knowledgeable about
computers. If necessary, I could flowchart a process to do what needs
to be done....
|
by: ccr |
last post by:
Reposted with a longer line length. Apologies if I did not cancel the 1st attempt before you got
it.
If necessary, please view in a text editor so the columnar text lines up. I used Terminal 9pt font
to compose this post and copied/pasted to my newsreader program.
I am writing in the hope that one of you Visual Basic experts may provide a solution, or at least
some insight, to the problem described below. I am not a programmer, but...
|
by: Usenet |
last post by:
Hi there,
I am quite a novice to MS Access, and I would deeply appreciate help on the
following:
I have created a list box in a form. I wish for that list box to enter
multiple values from table X
into table Y. Selecting the multi-select property and changing it to
advanced lets me select multiple
entries, but they are not transferred to the destination field
Could you please help?
| |
by: misscrf |
last post by:
I am currently working on a database, in 3rd normal form, which is for
candidates who apply for a job with the law firm that I
workd for. My issue is with good form design.
I have a main form. Then I have 3 pages on a tab control ( 4 if the
type of candidate validates that is is to be shown) Each page
has a subform. The subforms can be either single or continuous, I
think I am still deciding what I want to lock down this entry...
|
by: Kasghost |
last post by:
I am trying to create a DB in Access 2007 where the values in certain fields requires multiple entries.
I would like to send this DB out as an HTML to my techs and have them fill the information in.
The problem I am having is that I am having to create too many tables. I would really like to have no more then 3 or 4 tables.
I've been able to setup most of the tables so that each value has only 1 entry but when I get to the inventory...
|
by: TechnoAtif |
last post by:
<?php
include "dbconnect.php";
include "commonFunc.php"; ?>
<!---------------------------------->
<table width="80%" border="1" cellpadding="2" cellspacing="0">
<tr >
<td colspan="2"><p>
|
by: cssExp |
last post by:
Hi,
Assume i have two tables. "accounts" and "accounts_logs"
"accounts" (accid, type)
"accounts_log" (accid, ip, timestamp)
Here i want to choose a radom 3 accids from "accounts" if available, but each of them should be compared with "accounts_log".
Lests say a one of the accid chose is A1, then take users IP and current time - time(). now compare A1 exists in "accounts_log" with the ip, this can exist multiple times but pick one...
|
by: Phillipe |
last post by:
Hi, hope you can help with this query as it's had me stuck for quite a while.
I have two tables:
user table
-----------------
id (primary key)
firstname
lastname
|
by: marktang |
last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look !
Part I. Meaning of...
| |
by: Hystou |
last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it.
First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...
|
by: tracyyun |
last post by:
Dear forum friends,
With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
|
by: agi2029 |
last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own....
Now, this would greatly impact the work of software developers. The idea...
|
by: isladogs |
last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM).
In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules.
He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms.
Adolph will...
|
by: TSSRALBI |
last post by:
Hello
I'm a network technician in training and I need your help.
I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs.
The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols.
I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
|
by: adsilva |
last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
| |
by: muto222 |
last post by:
How can i add a mobile payment intergratation into php mysql website.
|
by: bsmnconsultancy |
last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...
| |