Subforms help... new to access...

N

Niko

Hi all,

I have a question regarding three tables from which one is the main
table the PostLetter(with some related info-fields like
date,sender,subject,etc), the other is the Theme and the last one is
the Department.
I want to make a form from which the main table will be updated with
new records, but one record can have multiple Theme and Department
values...So the form must contain (from what I've been reading) two
subforms.
The thing is that the user must select from existing values from Theme
and Department table so as to assign them to a PostLetter record.I
don't know how to do that... If someone could help me, please do so...

P.S I've made the 2 required junction tables for Theme and
Department relating to PostLetter table.
 
Top