If I have a form based upon a table where three fields are used as a compound primary key:




  • How do I relate this table with another one where the three-key table is the one side of the one-to-many?
  • When a user selects, through a combo box, three options that already exist as a record would the subform populate with existing data (accepting that the subform is opened by a button)? I know the answer to this is undoubtedly yes.
  • If the alternative was true and that the combination of the three does not match a record in the table, would the subform be blank; allowing for the creation of a new record in the alternative table?