User-1885804455 posted
Let's say I have two tables:
Table1:
Table1_ID (AutoNumber, Primary key)
Table2:
Table2_ID (AutoNumber, Primary key)
If I would create a junction table out of these two tables, then it also need to have two fields which both have primary keys as well, like this:
Table1_Table2_Junction:
Table1_ID (AutoNumber?, Primary key)
Table2_ID (AutoNumber?, Primary key)
But do they also need to have the datatype set to "AutoNumber" as well? Or could it just be "Number"?