Hello, in advance, im new to Apex. I created tables as follows:
CREATE TABLE TASKS(
TASKNAME Varchar(50),
TASK_ID Number(5) Primary Key
);
CREATE TABLE ASSIGNMENT(
USER_ID REFERENCES USERS(USER_ID),
TASK_ID REFERENCES AUFGABEN(TASK_ID)
);
Now I need your help: Does anyone know how to set "TASK_ID" as an autoincrement?
If i import data for the "TASKS"-Table, the foreign key in table "ASSIGNMENT" should count automatically, without loading data for this specific column.
Thanks for your help!