|
Sergey Kornilov admin 10/2/2010 |
|
You need to post your application to Demo Account and open a ticket at http://support.xlinesoft.com sending your Demo Account URL. 'Demo Account' button can be found on the last screen in the program. We need this info to provide a meaningful advise. |
|
|
A
|
arunabh author 10/27/2010 |
|
You need to post your application to Demo Account and open a ticket at http://support.xlinesoft.com sending your Demo Account URL. 'Demo Account' button can be found on the last screen in the program. We need this info to provide a meaningful advise.
|
|
|
A
|
arunabh author 10/28/2010 |
|
Sir, I will give you table structure for your information. ordermaster co int PK code char(2) PK docno int PK docdate datetime PK customerid int PK ordernumber orderdetail co int FK to ordermaster code char(2) FK to ordermaster docno int FK to ordermaster docdate datetime FK to ordermaster customerid int FK to ordermaster itemcd int salemaster co int PK code char(2) PK docno int PK docdate datetime PK customerid int PK saledetail co int FK to salemaster code char(2) FK to salemaster docno int FK to salemaster docdate datetime FK to salemaster customerid int FK to salemaster orderlink int FK to orderdetail(docno) itemcd int qty int rate decimal(10,2) itemmaster co int itemcd int itemname varchar(50) now when i go in saledetail for entering invoice i should select ordernumber column from ordermaster for that customer, pick the document no(docno) column and save in orderlink column of table saledetail. when i select order of that customer only, itemcd column will show part names (itemname) column of that order only from itemmaster. I think I have put in simplest form. Serjey, please help.
|
|