I have 3 tables. 2 child and 1 parent.

The child tables have foreign keys that reference the parent.

I assume(and tell me if I am wrong) that the foreign keys in the child tables(which also serve as Primary keys in these table) should not be set to auto-increment
since their values will be taken from the parent table.

Am I right?