I have a web database, with a form that submits data to a table (table1).
i also have another simple table (tableForCombo) that contains names, which are being shawn in a combobox.
i want the user to
open the form,
pick a value from that combobox and
store it in another table...
how can I do this, please?
As Mihail says, it's better to store the key elsewhere, rather than the item itself.
However, this sounds like you need to bind the ComboBox control (populated from [tableForCombo]) to the field in the form's Record Source, which should be [Table1]. Does this make sense?
7  1833 
That can be done, George, but is a bad BAD BAD approach.
In a database the things must be stored in a SINGLE place.
Take a look here: http://bytes.com/topic/access/insigh...ble-structures
If you don't change your mind after reading this, ask again and I'll help you with a solution.
To be honest, i realise the need of having adatabse normalized, but i dont understand why having a combobox storing from one table to another is not normal.. (The reason for this is that i really have no idea how to achieve that, alternatively..) can you help?
NeoPa 32,556
Expert Mod 16PB
As Mihail says, it's better to store the key elsewhere, rather than the item itself.
However, this sounds like you need to bind the ComboBox control (populated from [tableForCombo]) to the field in the form's Record Source, which should be [Table1]. Does this make sense?
yes. this is what i want to do.
i just had to set the second table's field as 'lookup' , point the lookup to the first table's field , and that's it..it works.
i really thank you.
but one question .
isnt my database normalised now???
Happy to hear that.
I can't say if your database is normalized now. Because a database is normalized if every structure (read table) of it is normalized.
But this was a big step to the normalization.
Of course, NeoPa and other like he from this forum can teach you a lot about. Sorry but I can't because my skill.
NeoPa 32,556
Expert Mod 16PB George:
isnt my database normalised now???
Although this is impossible to say without more information, there is nothing you've said which indicates that it isn't, so it could well be normalised.
If you read the linked article you will be able to tell if your structure and design represent normalised data.
Sign in to post your reply or Sign up for a free account.
Similar topics
by: home |
last post by:
Hi I wonder if someone can help.
I have a form that has a combo box that I use to select a customer. Ho do I
populate other fields on my form based on the value I have selected from the
conbo...
|
by: DD |
last post by:
I have frmMain and fsub
you choose a month from the ChooseMonth combo and all the records for
that month are nopw visible in the fsub
I know print with the following Where and only recieve the...
|
by: Art at ABE Computer Consultants |
last post by:
I'm missing something really simple, I'm sure. I have a form to be
filled in. The operator choosed a plant species (the botanical name)
from a list in a combo box. (The lookup table is populated...
|
by: Becker |
last post by:
I have a need for a simple combobox on a form in one of my programs that
represents city, state. I want to have it autocomplete as the user types.
I have a table with these values (about 50k of...
|
by: mike11d11 |
last post by:
I'm trying to create a combo box that has the only the field names from
a table in it and not the items in that field. So for example I have a
table with 40 fields in it like Account#, Name,...
|
by: Ahmad Jalil Qarshi |
last post by:
Hi,
I am developing a Windows Form based application in C# 2005. I have placed a
Grid control on the Form and using MS SQL server 2000 at back end. Now the
Grid is showing different columns from...
|
by: smiler2505 |
last post by:
I know it's a strange request to want to use a combobox in a table rather than a form, but if it's possible it would be good.
I know there is a ComboBox object, but all the useful references such...
|
by: buss123 |
last post by:
Hi all,
combo box script code was working in IE perfectly with all modes but OnChange event was not working in FireFox(editable mode, if we select valuese that combo box values r...
|
by: JFKJr |
last post by:
Hello everyone, the following is the Access VBA code which opens an excel spreadsheet and creates combo boxes dynamically.
And whenever a user selects a value in a combo box, I am trying to pass...
|
by: jimgym1989 |
last post by:
Hi there,
I have 2 PHP files, memeber.php & view.php
This is my member.php
while($row = mysql_fetch_array($strSQL)){
$data .= "<tr>";
$data .= "<td>";
$data .= "<input type='checkbox'...
|
by: Charles Arthur |
last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
|
by: BarryA |
last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
|
by: Sonnysonu |
last post by:
This is the data of csv file
1 2 3
1 2 3
1 2 3
1 2 3
2 3
2 3
3
the lengths should be different i have to store the data by column-wise with in the specific length.
suppose the i have to...
|
by: Hystou |
last post by:
There are some requirements for setting up RAID:
1. The motherboard and BIOS support RAID configuration.
2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...
|
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,...
|
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...
|
by: jinu1996 |
last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...
|
by: Hystou |
last post by:
Overview:
Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows...
|
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...
| | |
