Last post Sep 30, 2015 07:48 PM by Ptolemy
Sep 29, 2015 09:58 PM|Ptolemy|LINK
Let's say I have two tables:
Table1_ID (AutoNumber, Primary key)
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_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"?
Sep 30, 2015 03:02 AM|Li Wang|LINK
But do they also need to have the datatype set to "AutoNumber" as well?
They can't set to "AutoNumber". Just set to "Number" as well. AutoNumber is a
type of data used in
Microsoft Access tables to generate an automatically incremented numeric counter. It can't be insert or update. In your tables, the values of Table1_ID and Table2_ID are from
Table1 and Table2.
Sep 30, 2015 07:48 PM|Ptolemy|LINK
OK, I now realize that having it set to AutoNumber would ruin the whole concept of M:M relationship. So the point would be to be able to have repeated ID's in the Junction Table, either in the left or right field. This would be a problem if having boht field
as AutoNumber, and they're already set to AutoNumber or other unique ID in their respective table.