D
Dave
I have 3 tables: "Beads" containing a consistent 30 records,
"Samples"(Field:Sample Date) and "Results" (Field:Result). Beads has a
one to many relationship to Results, as does Samples. So Results is
effectively a linked table from the many-to-many relationship between
Samples and Beads.
In any case, I need a data entry form based on the sample with a
datasheet subform for Beads and Results. But I would like the Bead/
Result datasheet to show all 30 records with a blank spot to fill in
the results, rather than picking each of the 30 beads from a combobox
and entering the result. Is this even possible?
Thanks in a advance
Dave
"Samples"(Field:Sample Date) and "Results" (Field:Result). Beads has a
one to many relationship to Results, as does Samples. So Results is
effectively a linked table from the many-to-many relationship between
Samples and Beads.
In any case, I need a data entry form based on the sample with a
datasheet subform for Beads and Results. But I would like the Bead/
Result datasheet to show all 30 records with a blank spot to fill in
the results, rather than picking each of the 30 beads from a combobox
and entering the result. Is this even possible?
Thanks in a advance
Dave