My case is like this for example:

Form A [Product] which will have name of product and its cost.

From B [Order] which will lookup the product name from form A and fetch the cost of that product from form A too.

For adding record in form B, everything is fine.

Now when I update the cost from form A [Product], how can it automatically update in form B [Order] too?

I will have for example 10 records in form A [Product] and just some of them need to be change the cost.

But in form B [Order], it can have thousands of records which some of them will use same product in form A. If have to change the cost manually by hand in from B --> I'm gonna die :D

Not stop here. I'm stuck in Subform too.

When I do the subform with lookups and all of lookup need to be set criteria, it seem like just 1 or 2 first lookup work with criteria, the rest can not. Why? Is it a limitation for searching in lookup for subform.

I can do fetch record too but return as the case before, I need to update by another form.

Thanks for your help!