Hi There! Anyone could tell me the way, how this works? 1. I have a form related with table X 2. On the form there is a subform related with table Y 3. I want to summarize the field y in Table Y on the subform and put this value into a textbox located on the form How can I do this? I know, this is a lamer’s problem, but please help me, THX Chino22 MSN:email@example.com
Hi, The easiest way to accomplish this is to create a FLOW FIELD in table X based on value from table Y and display that field on Main Form.
You can check the Amount field on the Sales Header (Sales Order). Its a flow fields from the sales line table.