Table A
CHE_NO AMOUNT
456789 854
569859 6585
...
Table B
Bank Che_NO SUPPLY AMOUNT
XXXX 569859 WATER 6586
XCCX 456789 JAMES 854
1. Is there a way I can design a form where if I enter a che_no, it retrieves from both the table all the fields?
2. As one can see that amount for che_no 569859 is different. Is there a way a field can be created in DB which records the difference IF ANY.
THANK YOU!!!