Skip to main content
B
BuzzLightyear2
Inspiring
February 25, 2009
Question

Cannot Read Multiple Records

  • February 25, 2009
  • 4 replies
  • 1128 views
Sorry is this has been covered before.

I have a form which inserts value(s) into a table using the primary key. This is linked to another table so that when i use a query, it pulls the information and displays the name according to the primary key. This works fine when only one record is in the field, however, it has a problem recognising this when there is more than 1 entry to the field.

Could this be because a comma is used as a default seperator by Access if there is more than 1 entry (eg displays it as "1, 2, ...")

To infinity and beyond!
This topic has been closed for replies.

4 replies

B
BuzzLightyear2Author
Inspiring
March 3, 2009
This may not not be possible, but could you use cfloop to loop through the field/list, and select any values where the foreign key and primary key match?
N
Newsgroup_User
Inspiring
February 25, 2009
BuzzLightyear2 wrote:

> I think the problem arises as Access cannot differentiate between each number.
> Can you think of another way to do this?
>

Access can, but can you properly tell it to do so. I am unclear if your
problem is with an badly designed, unnormalized database scheme or an
unclear understanding of joins and or the "IN" clause.

A bit more description of what is going on would help. What are users
entering with examples. What are you doing with this input, with code.
B
BuzzLightyear2Author
Inspiring
February 26, 2009
Sorry for the confusion.
I have created a form in coldfusion which a user can submit when they have delivered a talk to as many as 25 people, this is then stored in access.
There is also the option to view each talk and who it has been delivered to (for example Joe Bloggs delivered the talk to Batman, Robin, Superman, ...).
This is fine when only 1 person is delivered the talk. When it is delivered to 2 or more people, coldfusion or access fails to display the names.

Thanks for your help, hope this clears things up a little bit...
B
BuzzLightyear2Author
Inspiring
February 25, 2009
It may be bad design - I have set up a form in which someone can deliver a talk to many people, this isnt a problem, the problem arises when I try to perform a query to read out the people who have had a talk.
I think the problem arises as Access cannot differentiate between each number.
Can you think of another way to do this?
D
Dan_Bracuk
Inspiring
February 25, 2009
More than one entry to the field? If that's in a single record, your problem is a bad database design. I've heard good things about the book, Database Design for Mere Mortals.
Terms & ConditionsAccessibility statement
Using the community Terms of use Privacy Cookie preferences Do not sell or share my personal information ad choicesAdChoices