Data from one table to another q

[dinadvani via AccessMonster.com]

Hello,

Can some one help me to pull data from one table to another.

I have two tables
Table 1 - Amount estimation
Table 2 - Payments

Now I want to calculate the variation between amount received and expected
amount. But the problem is in Payments I dont have expected amount. Is it
possible to link or do something to auto populate expected amount from in
Payments form.

field names are
Expected Amount (ID) - in table amount estimation
Actual amount (ID) - in table payments

Please advice

Thanks,
DA

 

[Guest]

Hi DA,

If there is some way of linking the tables through a primary key/foreign key
pair, then you can simply link them on those fields then utilise fields from
each table in your query. eg:

Select * from [Amount Estimation] inner join [Payments] on [Amount
Estimation].ID = [Payments].ID

Damian.

 

[dinadvani via AccessMonster.com]

I forgot to mention the criteria the unique id no. is "Service ID" based on
which the expected amount (ID) should get auto populated