DBPro Save fields to two tables - Forum

Forum Navigation
You need to log in to create posts and topics.

DBPro Save fields to two tables

Sorry for a what sounds easy question but I need some help to understand it.

I want to Create a new record in Table B, and save the data from three fields to another table(A) as well. Then Copy the ID from Table A back to Table B, so creating Relationship between the two table.

Table B >>                                 Table A

First-name            >>                    First-name

Middle-name        >>                    Middle-name

Surname                 >>                   Surname

ID                             <<                    ID