Access subdata sheet

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am creating a Video Collection in Microsoft Access. I have a subdata sheet that provides brief details of each movie, but each movie that i have in the list shows the same detail that does not pertain to the specific movie. Can anyone help????
 
Jay

You haven't indicated where you are viewing the related information. Via a
subform, from a main form is the preferred approach, rather than directly
from a table.

If you are using a main form/subform setup, how is the subform linked to the
main form?
 
-----Original Message-----
I am creating a Video Collection in Microsoft Access. I
Click to expand...
have a subdata sheet that provides brief details of each
movie, but each movie that i have in the list shows the
same detail that does not pertain to the specific movie.
Can anyone help????
.
Check that the sub data form has the Link Child Fields and
Click to expand...
Link Master Fields set to the field that links the two
tables. The easiest way to do this is to drop the sub data
form, and recreate it with the subform wizard. This will
ask you how you want to link the two tables.
 
Back
Top