Form feeding a table problem

  • Thread starter Thread starter kev5
  • Start date Start date
K

kev5

I am a newer user of Access and inherited a database from a person no longer
with the company.

I am using a form to input invoice amounts into an invoice table. The form
uses a parameter query to ask for invoice number. When the form opens, I
have it pulling customer info from a customer table, which it displays on the
form. I then enter more invoice info. When I look at the invoice table
after I close the form, the info I typed (invoice update) is there, but the
customer info that is automatically pulled doesn't load from the customer
table to the invoice table.

How can I get the customer data to load into the invoice table at the same
time that I enter the invoice update? Thanks.
 
Kev,
a database is relational, the invoice table would have a customerID in each
row that relates each row back to the correct customer in the customer
table.
It's not good practice to store the customer information in the invoice
table.
When you want to know the customer details for a particular invoice, you
create a query that pulls up the correct customer info for the invoice no.
you have.

Jeanette Cunningham
 
Back
Top