Realtioinshio between tow Tables...With condition

[Nader]

In the first thank you for this sitea and I'll use a pic to express What I want because my language isn't very well.
Here are tow tables (Table2,Table3).
I want to make relationship between them Where, in the F column of Table2 will Sum the numbers in F column of Table 3 according this condition ( as it show in the pic.):

For the SIMILAR data in columns(B,C,D) between two tables
Example: Table 2 include in B,C,D data HH XX FF
There are many data (HH XX FF) in tables3 in same columns(B,C,D) so it will sum the numbers in F column that in the same row with the data (HH xx FF), and insertded the results in the in Table2 in F colmn in the same row with (HH XX FF )

And Tahnk you for help.

 

[MStef]

What is the keys in your tables, (primary key, foreign key) ???

 

[Nader]

There is no key.

 

[NigelShaw]

hi

You are best relating the tables with primary and foreign keys. Primary in table 2 and foreign in table 3.

Also

Use a query to sum your fields as you don't really sum in tables. A table is store data and a query is to use it, change it, create it etc.

If your table3 needs to hold the sum data of table2, you can do it with an append query.

Nigel