Form to Use Data to Add to Another Table

[maSProductions]

Hello fellow Access user

Explanation

I want to make a Report to Gather information from multiple tables in a Report then apply that information in a single table.

This is what I have 3 Tables

• CustomerTable
• ProductTable
• InvoiceTable

I then want to make a form that will get information form each table
From CustomerTable

• CustomerName
• CustomerAddress

From ProductTable

• ProductName
• ProductPrice

Lastly After choosing this information with the addition of "DateShipped", "AmountPurchase" and maybe a "TotalPrice" I would like to apply it to the InvoiceTable to held for future use.

The Plan

In the Grand Scheme of things this is the first step in trying to make easy to use database to hold all of their invoices and a lot of other business data so that my parents can understand it and use it easily

Final Thought

I am very new to Access and understand that my thought process on this may be off and I may need to go about this a different way. I am willing to accept any suggestions.

 

[mikejaytlabustro]

Customer Table: Customer ID, Customer Name, Customer Address
Invoice Table: Invoice ID, Customer ID, Date Shipped, Amount
Product Table: Product ID, Price
Order Table: Order ID, Invoice ID, Product ID, Description, Amount
-----------------------------------------------------------------
Establish Relationships under Data Base Tools
Then you can create a query and report based on the data
No need to make another table.
-----------------------------------------------------------------
I am using Access 2007. Willing to help you as long as i can.

 

[John Big Booty]

An important concept that you will need to grasp when designing an efficient DB is that of Data Normalisation, you may also want to work through a tutorial on the subject.