I'm doing a small tool to make it easy for us to print store requisitions by selecting the materials from a list then filling the datagrid.
once done, all will be stored in a database as shown below. (I've done all procedures and the program lack the printing thing)
the database (STRE):
table[req]:serial(PK: auto number), project(varchar), prijectID(varchar), orddate(date)
table[det]:id(PK: auto number), serial(FK: number), matcode(varchar), matdet(varchar), unit(varchar), qty(number).
I don't know how to make the report, suppose I want to print the items which we ordered from store which having the serial number (3).
please help me if any one knows the solution.
the data must be pulled from 2 tables on the FK(det.serial).