Cara membuat Queries

Before making the "Queries" you need to make some information in the database (Table). for example the picture below I have made ​​about "Booking", "Customer", "Delivery", "Product".

After that, the new is you begin to create "queries". Click on the "queries" and click on "create query by Using the wizard. "

when click on the "Create query by Using the wizard, "you will see a box that will appear on the display screen. After that, select  "Query: Booking Receipt" and enter the information in the box  "Available Fields" in the "Selected Fields".

Information-information such as: -
* Cust No
* Cust Name
* Cust Mobile
* Product ID
* Product Name
* Booking No
* Date Book
* Price Perunit
* Quantity
* Grant Total

next

next

and this result

then close the "Query: Booking Receipt" and click on "Create query in Design view. "

 

 

two tables will appear on your screen display. Next on the "Show Table" you need to select information about the "Booking", "Customer", and "Delivery". How to choose, you Crtrl button and click on the information. After that click on "Add" button.
   

and this result

After that save the state table in the name of "Payment Receipt". And click on the button "ok".

Next you need to fill in the blank boxes with the information in the "relationship"on it. you need to drag

* Cust No

*Cust Address

* Cust Mobile

* Cust Name

* Booking No

* Date Book

* Grant Tot

* Payment Date

* ID Delivery

* Delivery Date

* Type of Delivery

and enter the information into the boxes available

and save it.