Re: Subform shows wrong record

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

For some reason my last post only recorded your entry. Let's try again.
First of all, I don't know what a foreign key is, but I'll tell you what I
have set up.
Main table: Member personal data (primary key = student id)

Linked table: Drivers license (one to one relationship with full referential
integrity enforced). it is linked by the student ID number. In this table I
also have student ID as a primary key.

The form Licenses Record has a search box with the following fields from
Member personal data:
student id - hidden, but linked
last name, first name and middle name

This form has a subform which is based on the info in Drivers table.

Does that help? I'm not an expert at this as you see so I'm not sure what
other info I can give to help you :-(

"Jeanette Cunningham" wrote:

It's most likely that the problem is related to the way the tables are set
up.

Would you post the names of the tables, the primary key and foreign key for
the table and the relationships between the tables.


Jeanette Cunningham MS Access MVP -- Melbourne Victoria Australia



"BVM" <BVM@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:31EF6A6C-21C7-4C8D-B7CF-561519F7B8A2@xxxxxxxxxxxxxxxx
Thanks Jeanette, but I'm sure that the students don't have more than one
license record. I've even checked the tables and it shows me the correct
record when I open from tables so I know the correct info is there. The
problem is when I open the form. Does that make sense? Maybe the search
list
wants to have a more specific criteria to search by, but each student has
a
unique ID so I don't know why it gets confused with some last names :-(
Any
ideas?
Thanks.
BVM

"Jeanette Cunningham" wrote:

Hi BVM,
This line-->
I've > noticed a pattern that the second record (i.e. data entered after
the
already
existing record) assumes the same license info as the prior record.
-->
suggests that the same student can have more than one license record.
Does it make sense for your database that any student can have more than
one
license record?



Jeanette Cunningham MS Access MVP -- Melbourne Victoria Australia


"BVM" <BVM@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:29F5BEA2-3901-4EAA-8512-9146FB38DD29@xxxxxxxxxxxxxxxx
Hello there, I will try to explain this well even though I'm a little
confused...
-I have a form with a seach list and a subform
-The search list is linked the subform (Licenses) by the student ID
which
is
a unique key
-When I select names from my list I often get the correct license
record
except when two record in the search list have the same last name. I've
noticed a pattern that the second record (i.e. data entered after the
already
existing record) assumes the same license info as the prior record.

I don't know where to go from here. I also have a main table (member
personal data) which contains the ID number, names etc and I created a
one
2
one relationship with the Student ID field in the license table. I can
open
the license table and the correct information appears for every record
when I
expand the subdatasheet. The problem seems to be in the form. Does any
one
have any idea of what I should do? Hopefully it's something simple. I
have
other tables linked to my main 'member personal data' table and I'm
nervous
about messing it up. Help!






.

Relevant Pages

  • Re: Subform shows wrong record
    ... "Jeanette Cunningham" wrote: ... Put a student's drivers license details in the same table as the member ... Make a one to many relationship between the member personal data table ... This allows the possibility for each student ...
    (microsoft.public.access.forms)
  • Re: Subform shows wrong record
    ... Jeanette Cunningham MS Access MVP -- Melbourne Victoria Australia ... record when I open from tables so I know the correct info is there. ... suggests that the same student can have more than one license record. ...
    (microsoft.public.access.forms)
  • Re: Subform shows wrong record
    ... Put a student's drivers license details in the same table as the member ... Make a one to many relationship between the member personal data table ... This allows the possibility for each student ...
    (microsoft.public.access.forms)
  • Re: Subform shows wrong record
    ... user can choose a student to search? ... If, in your case, you have tblStudent, with a Primary Key of StudentID, and ... Member personal data ... Drivers license (one to one relationship with full ...
    (microsoft.public.access.forms)
  • Re: Subform shows wrong record
    ... Jeanette Cunningham MS Access MVP -- Melbourne Victoria Australia ... record when I open from tables so I know the correct info is there. ... suggests that the same student can have more than one license record. ...
    (microsoft.public.access.forms)