Hi all,
How to increment an ID field with "Number" as data type in an Append query?
That is, inserting fields from Table1 into Table2, relationship is 1 to many. The link between both tables is that primary key of Table1(ID)is a foreign key in Table2. Table2 has its own primary key.
Therfore, what is required, is to Append Table2 and increment the primary key.
Thanks in advace for your help.
How to increment an ID field with "Number" as data type in an Append query?
That is, inserting fields from Table1 into Table2, relationship is 1 to many. The link between both tables is that primary key of Table1(ID)is a foreign key in Table2. Table2 has its own primary key.
Therfore, what is required, is to Append Table2 and increment the primary key.
Thanks in advace for your help.