I have created four tables to my database, all with minimal information as this is practice for me. The tables are customer, order, order details, and product. I’ve created relationships between them. I’ve created two queries. 1 is using customer and order table and the second uses tables order details and products. I’ve made a form with the first query and a subform using the second querry containing ordered,productid, description, quantity, charge and a total Feild of charge*quantity. I am looking to have a listbox for description and quantity and display the charge price. Is this possible with very limited database knowledge.
You can download the Base Guide here for free.
There it is described how you can create your form with little knowledge using the wizard. Prerequisite is that your tables and links are created correctly.
Hello. I am new to this. I have taken your suggestion and have read and studied the LO Base handbook. Questions still remain and will try to clarify with more detail. My goal is to make an order form. My idea is to make a main form with my customer table.
tblCustomers
CustomerID PK
LName
FName
Phone
Then I created a querry from:
tbl Order
OrderID PK
CustomerID FK
Date
Notes
tblOrderProduct
OrderID FK
ProductID FK
Quantity
tblProduct
ProductID PK
Description
Charge
Notes
Category
I’ve created the relationship of the tables prior to making querry. The querry feilds on design view are customerID from order tbl,date from tblOrder, OrderID, ProductID and Quantity from tblOrdPro, description, charge from tblProd. and a sum total function of Charge*quantity. I’ve nested the querry in into main form, linking customer ID to Customer ID. I would like list box to populate subform columns. This is my second comment and am very new to forums and database. Thank you.