UPdate one table from another table through form?

[ssworthi]

I have a reference table that I have created a form from. I enter the id and all the pertinent data for that customer. I want to populate a monthly invoice table with those fields and the monthly invoice table. Do I create an update query and have a command button to run that query in the form to update the fields in the invoice table. I'm I don't know any code; I'm query level.

Thanks for your help!

 

[jzwp22]

...populate a monthly invoice table with those fields and the monthly invoice table

You would not duplicate the information from one table in another, that would violate a key principle of relational databases.

If you want to record multiple monthly invoices for customers, you have a one-to-many relationship; you would only have to establish a relationship between the two tables. Something along these lines

tblCustomers
-pkCustID primary key, autonumber
-txtCustomerName


tblCustomerInvoices
-pkCustInvID primary key, autonumber
-fkCustID foreign key to tblCustomers (long number field)
-dteInvoice (invoice date)
-currInvAmt (invoice amount)