hello,
table1_ProductList -> has the following fields:
ID (primary key,auto number)
SERNO(text)
DESCR(text)
PRICE(currency)
table2_Jobcard -> has the following fields:
ID (primary key,auto number)
PROD_DESCR_ISSUED (droplist, get 'prod desc' value from table1)
PROD_QTY_ISSUED (decimal)...