Retrieve data from more than one table, on a single form on entering a field.

[suverman]

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!!!

[alansidman]

Create a query joining the two tables on the check no. Create an expression field to calculate any differences. Use the query as your record source for your form to display the information. A bigger question is why do you have two tables containing the same information? This goes against the normalization rules. Based upon what I see here, all this information could be in one table. Are there other factors or fields involved?

Alan