I need to have a relationship that when I enter a new record in Table1 it adds the number of records in Table 2 into Table 3. I am not for sure if I should use a Join or Link. Hopefully my example will help.
this is lil bit tricky question and u seems to be lazy ;-) sorry just joking
U can easily do this in VBA in the AFTER INSERT EVENT. I dont think( from my scope) Cascade Update links work here in your example while inserting a new record. Anyway seek better answers. all the best