Auto fill data

narufeesh

New member
Local time
Today, 06:40
Joined
Apr 5, 2017
Messages
4
i am a new to database & learning,

i am creating a small database. the invoice form have to select the data from goods table by entering primary data.

the table structures are

1. goods table have "GOODS NAME (PK), PACKING METHOD, UNIT PRICE, MAIN SUPPLIER,"

Invoice table have "ID (PK), INVOICE NO, INVOICE DATE, SUPPLIER, TOTAL"

Invoice details table have "ID (PK), INVOICE NO, ITEM DESCRIPTION, QUANTITY, PACKING, UNIT PRICE, TOTAL"

i am doing my invoice form is as follows
*in the main form invoice information will be there. i will enter the invoice no invoice date. i will select the supplier from the drop down list.

* all i need is following in subform
* i already select the suppliers so item description of above supplier only have to be presented
* if select the a item then the form have to be auto fill the PACKING & UNIT PRICE.
* total in invoice main form have to be auto fill based on sum accumulated in the subform.

i am waiting to hear from you since i am new to db system & hope some of you may give me better idea to learn about this.

thank you very much in advance
 
you run an update query.
the query adds the GName,Price,(and supplier if you want) to the tInvDetails table,
based on the item the user picked.
 
you run an update query.
the query adds the GName,Price,(and supplier if you want) to the tInvDetails table,
based on the item the user picked.

Please explain me how since i am new to db system i need thing in clear

thank you very much again
 

Users who are viewing this thread

Back
Top Bottom