Hi all
i am working on a hospital inventory system, can any one help me with my problem--ie i have made:
1. Transaction table: Fields include both sale and purchase field
2. Transaction Type: include Sale,Purchase and sale purchse return
3. table 2. is look up table in table 1
4. Is there any way in which i can display related fields in form eg if i use drop down in transaction table ie sale it will show me bill details and if i use purchsase it will hide bill details and show related fields
i am working on a hospital inventory system, can any one help me with my problem--ie i have made:
1. Transaction table: Fields include both sale and purchase field
2. Transaction Type: include Sale,Purchase and sale purchse return
3. table 2. is look up table in table 1
4. Is there any way in which i can display related fields in form eg if i use drop down in transaction table ie sale it will show me bill details and if i use purchsase it will hide bill details and show related fields
