how to insert subform data to specific table. please help

[kohluis995]

I have problem with inserting sub-form data to specific table. i have 2 table and one form.
table A is for DLOOKUP, table B is the table i want my sub-form data to insert in.
my table A have ID,name and class.
my table B have ID and other column.
Table A' ID and Table B' ID is related.

i trying to insert my sub-form to table B instead it insert the data to table A.

if there is any solution please help me.
many thanks !

[June7]

What do you mean table A is for DLOOKUP? DLookup is a domain aggregate function.

Don't understand tables and relationship. Exactly what is this data for? What is the other column in table B? What do you mean you have one form? If you have a subform then you must have 2 forms.

If you want to save the ID from table A into a record in table B, then set the form RecordSource to table B. Create a combobox that has table A as RowSource. Set the combobox ControlSource to the 'other' column in table B.