i am trying to do an invoice database. 1 table has the invnum,custmerno,invoicedate. the other table has invoiceno,prodid,quanty,vatrate

should i have it the main formbound the the first table and the subform bound to the second.

in the subform i want to be able to pick the product from a combo box and the other fields fill out