Form data

[Guest]

I notice that in a Form that inputs to various tables that only certain
records are 'viewable' when scrolling back/forwards - why would this be?

Many thanks in advance.

Martin

 

[Jeff Boyce]

Martin

A form in Access only shows what its underlying record source allows it to
show. What is the source for your form?

Regards

Jeff Boyce
Microsoft Office/Access MVP

 

[Guest]

Jeff

Thanks for getting back to me.

The form is 'queried' to;

SELECT Students.[First Name], Students.Surname, Students.[Tel No],
Students.[Mobile No], Students.DOB, Students.Comments, Preferences.[Pref
Day], Preferences.[Anticipated Level], Preferences.[Pref Course] FROM
Students INNER JOIN Preferences ON Students.[No]=Preferences.ID;

If I input a number of records it appears only certain ones (and always the
first one) appear.

 

[Jeff Boyce]

I'm not sure why only the first one would show, but the SQL statement
includes an Inner Join. If there are no "matching" records in the
Preferences table, the query won't return any student data.

I'm a little unclear on the structure and relationship of your tables. From
the SQL statement, it looks like you have a one-to-one relationship. In my
domains, individuals could have multiple preferences (one-to-many).

Regards

Jeff Boyce
Microsoft Office/Access MVP

Jeff

Thanks for getting back to me.

The form is 'queried' to;

SELECT Students.[First Name], Students.Surname, Students.[Tel No],
Students.[Mobile No], Students.DOB, Students.Comments, Preferences.[Pref
Day], Preferences.[Anticipated Level], Preferences.[Pref Course] FROM
Students INNER JOIN Preferences ON Students.[No]=Preferences.ID;

If I input a number of records it appears only certain ones (and always
the
first one) appear.

Martin

A form in Access only shows what its underlying record source allows it
to
show. What is the source for your form?

Regards

Jeff Boyce
Microsoft Office/Access MVP

 

[Guest]

Ok, thanks Jeff - I have changed the relationships to 1-many in the SQL
query window - seems to work now (although I struggle with understanding
relationships!) - Thanks for your help.

I'm not sure why only the first one would show, but the SQL statement
includes an Inner Join. If there are no "matching" records in the
Preferences table, the query won't return any student data.

I'm a little unclear on the structure and relationship of your tables. From
the SQL statement, it looks like you have a one-to-one relationship. In my
domains, individuals could have multiple preferences (one-to-many).

Regards

Jeff Boyce
Microsoft Office/Access MVP

Jeff

Thanks for getting back to me.

The form is 'queried' to;

SELECT Students.[First Name], Students.Surname, Students.[Tel No],
Students.[Mobile No], Students.DOB, Students.Comments, Preferences.[Pref
Day], Preferences.[Anticipated Level], Preferences.[Pref Course] FROM
Students INNER JOIN Preferences ON Students.[No]=Preferences.ID;

If I input a number of records it appears only certain ones (and always
the
first one) appear.

Martin

A form in Access only shows what its underlying record source allows it
to
show. What is the source for your form?

Regards

Jeff Boyce
Microsoft Office/Access MVP

I notice that in a Form that inputs to various tables that only certain
records are 'viewable' when scrolling back/forwards - why would this
be?

Many thanks in advance.

Martin

 

[Jeff Boyce]

To get the best use of Access' features and functions, it would be worth
your while to spend a bit of time brushing up on "relationships" ... they
are pretty much at the heart of a relational database like Access!

Good luck!

Regards

Jeff Boyce
Microsoft Office/Access MVP

Ok, thanks Jeff - I have changed the relationships to 1-many in the SQL
query window - seems to work now (although I struggle with understanding
relationships!) - Thanks for your help.

I'm not sure why only the first one would show, but the SQL statement
includes an Inner Join. If there are no "matching" records in the
Preferences table, the query won't return any student data.

I'm a little unclear on the structure and relationship of your tables.
From
the SQL statement, it looks like you have a one-to-one relationship. In
my
domains, individuals could have multiple preferences (one-to-many).

Regards

Jeff Boyce
Microsoft Office/Access MVP

Jeff

Thanks for getting back to me.

The form is 'queried' to;

SELECT Students.[First Name], Students.Surname, Students.[Tel No],
Students.[Mobile No], Students.DOB, Students.Comments,
Preferences.[Pref
Day], Preferences.[Anticipated Level], Preferences.[Pref Course] FROM
Students INNER JOIN Preferences ON Students.[No]=Preferences.ID;

If I input a number of records it appears only certain ones (and always
the
first one) appear.

:

Martin

A form in Access only shows what its underlying record source allows
it
to
show. What is the source for your form?

Regards

Jeff Boyce
Microsoft Office/Access MVP

I notice that in a Form that inputs to various tables that only
certain
records are 'viewable' when scrolling back/forwards - why would this
be?

Many thanks in advance.

Martin