Subdatasheet problem

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

Guest

Hi everybody..
I have two questions.

1) I just want to learn whether it is possible or not to create
subdatasheet, if my tables dont have primary keys? If there is a way how can
I do that?

2) If my primary key consists of two fields in the same table how can I tell
Access this situation?
 
As to your first question, yes you can create a subdatasheet without having a
primary key in the main table. If you use the subform wizard, it will allow
you to create your own join between the 2. As for the 2nd question, I am not
sure, but I would assume that again using the subform wizrd will help you
around this.

HTH.
 
Can you please explain how can I create subdatasheet without having a
primary key in the main table..(Actually its query not a table) I will
explain what I want to do briefly..I have two subforms. First one is
Transcript which holds all the courses that student takes. Some courses have
subcourses and my second subform "Subcourses" holds that courses and I want
to merge these two subform as a subdatasheet form. After I placed my
"Subcourses" subform on the main form and then right click the subform and
change the Source Object property to "Transcript" query. Can you please tell
me where I am making mistake??
 
Back
Top