hey
I am quite beginner in Access. I have a problem with data entry form.
In a form I want to put one question which will allow mulitple answer. I want to store this anwers in one column.
For example: i want to store the record that tell me that the article was about politics and sport. In the table I have the column: Information type. I want to record this both (politic and sport) elements into one column (information type). How can I do it?
When I chose the multi select option this column wasn't fulfilled.
Lets say i have a structure:
News Table:
- Title
- Information Type
- Source
-Source Type etc.
Information Type Table:
- Sport
- Politics
- Economics
In news table i want to have in information type: sport and politics together.
So that i can receive:
title ¦ politics,sport ¦ Le Figaro ¦ Newspaper
How to do it?
8 2204
You are asking how to create a non-normalised table structure :-) In your own best interest, I'm not going to tell you how to do that! However, I will try to explain the reason, and method to correctly do what you want.
Your News table and your Information Type table have a Many to Many relationship. This means that one record in the News table can be related to any number of records in the Information Type table. Conversely, one record in the Information Type table can be related to any number of records in the News table.
Very well and good, you say, now what? The normal way to handle this is to create a third table that links to the two into two One to Many relationships. This table will be called something like NewsInfoType and will have three fields:
NewsInfoTypeID, AutoNumber Primary Key;
NewsID, Number, Foreign Key;
InfoTypeID, Number, Foreign Key.
(note that you do not list the NewsID or InfoTypeID fields in your current data structure, you will need to create them, or replace them with the field names of the field(s) you are using as the Primary Key, unique identifier in each table)
Regards,
Scott
You are asking how to create a non-normalised table structure :-) In your own best interest, I'm not going to tell you how to do that! However, I will try to explain the reason, and method to correctly do what you want.
Your News table and your Information Type table have a Many to Many relationship. This means that one record in the News table can be related to any number of records in the Information Type table. Conversely, one record in the Information Type table can be related to any number of records in the News table.
Very well and good, you say, now what? The normal way to handle this is to create a third table that links to the two into two One to Many relationships. This table will be called something like NewsInfoType and will have three fields:
NewsInfoTypeID, AutoNumber Primary Key;
NewsID, Number, Foreign Key;
InfoTypeID, Number, Foreign Key.
(note that you do not list the NewsID or InfoTypeID fields in your current data structure, you will need to create them, or replace them with the field names of the field(s) you are using as the Primary Key, unique identifier in each table)
Regards,
Scott
Ok thx :) i tried out sth...
but still i cannot do it :/ I think i am to stupid.
Ok so ...
I created that many to many relationship.
but is it ok if it is like that
InfoType: NewsInfo
ID 1-------------many InfoID NEWS
Information Type NewsID many------------1 ID
information type
source etc.
i created automatic form for the NEWS table and in information type option i put multi selecet. but then it doesnt record that info types (politics and sport) in the table. why?
Maybe I should change sth in tables?
greets
Greg
Ok thx :) i tried out sth...
but still i cannot do it :/ I think i am to stupid.
Ok so ...
I created that many to many relationship.
but is it ok if it is like that
InfoType: NewsInfo
ID 1-------------many InfoID NEWS
Information Type NewsID many------------1 ID
information type
source etc.
i created automatic form for the NEWS table and in information type option i put multi selecet. but then it doesnt record that info types (politics and sport) in the table. why?
Maybe I should change sth in tables?
greets
Greg
Hi Greg,
I'm assuming that you have created the correct relationships in the relationships window.
Now you'll need to create a query that will display the information you want for each field. All three tables will be included in this query, and then you will base you form on this query, instead of a table.
Regards,
Scott
Hi Greg,
I'm assuming that you have created the correct relationships in the relationships window.
Now you'll need to create a query that will display the information you want for each field. All three tables will be included in this query, and then you will base you form on this query, instead of a table.
Regards,
Scott
Ok but how to make that in one field there will be sport and politics together (from that InfoType table)?
Ok but how to make that in one field there will be sport and politics together (from that InfoType table)?
I'm assuming that you want to show these values concatenated into one text box control on your form?
If you don't mind my asking, why not use a continuous subform that shows each info type associated with the record you are working with on the main form?
Regards,
Scott
I'm assuming that you want to show these values concatenated into one text box control on your form?
If you don't mind my asking, why not use a continuous subform that shows each info type associated with the record you are working with on the main form?
Regards,
Scott
Hey Scott,
I dont know how to create that as well :)
Actually at this level I would like to save this values, rather than showing them :)
And i read somewhere that i can do it via VB (but i have no idea about programming in VB). As you wrote, I want to show these values concatenated into one text box - in the "Info type" column i would like to obtain "sport , politics".
I read somewhere that i can use multi select option and then i can select couple of info types. but when i try to add record it doesnt save me the info type. it stays null. I read that there is a special VB code for that to work. Maybe do you know that?
I realize that my answer become quite unorganized but i was reading too much on the forums and now i am confused. :)
greets
Greg
Hi Greg,
At this point, may I make a kindly suggestion? There are a number of books that are very handy references. The one I keep on my desk at all times is called 'Special Edition Using Microsoft Office Access 2003', published by QUE software. It's available fairly cheaply on Amazon.com.
The book will present the information you need to know to accomplish what you wish in a far more linear fashion than what you will find on the internet in any forum anywhere.
I suspect that most of your confusion comes from looking at too many different sources!
Regards,
Scott
Hi Greg,
At this point, may I make a kindly suggestion? There are a number of books that are very handy references. The one I keep on my desk at all times is called 'Special Edition Using Microsoft Office Access 2003', published by QUE software. It's available fairly cheaply on Amazon.com.
The book will present the information you need to know to accomplish what you wish in a far more linear fashion than what you will find on the internet in any forum anywhere.
I suspect that most of your confusion comes from looking at too many different sources!
Regards,
Scott
ok thanks I will try to search for sth there...
greets
Greg
Sign in to post your reply or Sign up for a free account.
Similar topics |
by: Rima |
last post by:
I have the following two tables :
table a
(commit_id,
capital_market_id,
chg_lst_date
)
table b
(b_seq_id,
|
by: google |
last post by:
Hello,
I am trying to create a listbox that users can select multiple
entries on. I want Access to put each on of those selections in a
different row on a particular table. This table will also include the
primary key of the parent form of the form that has the listbox. Here
is the code that I have. Right now it will put all of the selections
from the listbox into one row.
Private Sub Category_Click()
|
by: Deep Silent Ocean |
last post by:
Hi All
I am developing one Portfolio Management application where there is
single database shared by all the traders.
I have developed web-based application for this. I want to make this
multiuser application.
Following is the architecture of the application ...
|
by: CindyH |
last post by:
Hi
Does anyone know how to create a multi column combo box from the same table?
Thanks,
Cindy
|
by: DFS |
last post by:
You might also find other uses
=========================================================
Public Function getSelections(selType As String, selSeparator As
Boolean, selList As ListBox, selCol As Byte) As String
'BUILD IN CLAUSE FROM ITEMS CHOSEN IN MULTI-SELECT LIST BOX
'ARGUMENTS
'selType = text or number
| |
by: pmarisole |
last post by:
I am trying to use the vbscript "split" function on a multi-select
field. I am trying
to do a mass update of several records at a time.
I am getting an error and I'm not sure what to do. Here is the code if
someone could help...
strID = split(request.form("proj"), ", ")
projstat = split(request.form("rojstat"),",")
impr = split(request.form("impr"),",")
idate =...
|
by: freetime |
last post by:
Greetings,
This is my first post so I will try to be brief and accurate.
I have a report that uses 9 user selectable filters (Dates, Y/N's as Combo Boxes and 4 Multi-Select List Boxes. 2 of the Multi-Select Boxes acquire their data from other tables as Lookup's. All functions for the filters operate properly pulling the data needed. One of my options with the data is to send it to a Report that can be printed.
The request...
|
by: dbuchanan |
last post by:
There are three parts to this
1.) How do I cascade menus?
2.) And, how do I cascade menus with a multi-select CheckBoxList?
|
by: moorejim2 |
last post by:
Hello All:
I'm new to this forum and the creation of ms access as a multi user desktop application.
I have created a tool for the end user to enter data elements for counts of incidences on a certain day. To setup this process I have a form that first prompts the user to load the unique satation in which they work. This opens a second form which allows the user to select the appropriate date and then enter the data in the appropriate...
|
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: Oralloy |
last post by:
Hello folks,
I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>".
The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed.
This is as boiled down as I can make it.
Here is my compilation command:
g++-12 -std=c++20 -Wnarrowing bit_field.cpp
Here is the code in...
|
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 tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth.
The Art of Business Website Design
Your website is...
|
by: conductexam |
last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one.
At the time of converting from word file to html my equations which are in the word document file was convert into image.
Globals.ThisAddIn.Application.ActiveDocument.Select();...
|
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: 6302768590 |
last post by:
Hai team
i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
|
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...
| |