I need to concatenate the fields of a form and subform. I have established one to many relationship in two tables. One is record source for parent form and Many part is for subform.
Main form has fileds such as:
Department
IndentBy
ApprovedBy
Subform has fields such as:
Material code
Quantity -
MaterialName
StockAvailable
IndentQty
In the subform, first a record involving subform fields should be concatenated then next record shall be concatenated to this and so on. So if the subform contains many line items, all shall be concatenated.
The resultant should appear on the parent form. Then the fields available on the parent form shall be concatenated to the resultant of subform.
I am struggling to find out way to do so.:banghead:
Main form has fileds such as:
Department
IndentBy
ApprovedBy
Subform has fields such as:
Material code
Quantity -
MaterialName
StockAvailable
IndentQty
In the subform, first a record involving subform fields should be concatenated then next record shall be concatenated to this and so on. So if the subform contains many line items, all shall be concatenated.
The resultant should appear on the parent form. Then the fields available on the parent form shall be concatenated to the resultant of subform.
I am struggling to find out way to do so.:banghead: