Use a junction table with at least two foreign key fields.
Turn off indexing for the primary key field.
Use the primary key from the table on the "one" side as a foreign key in the table on The "many" side.
Turn off indexing for the foreign key field.
Enable referential integrity
Turn on indexing for the foreign key field without allowing duplicate values.
Turn on indexing in the foreign key field, but allow duplicate values.
Allows you to "orphan" data safely.
Keeps primary and foreign key values in synch.
Takes the place of an index.
Add the primary keys from A and B to a "link" or "junction" table.
Add as many fields as needed from table A to table B, and vice versa, until each table contains all the data you need to track.
Create one-to-one relationships between A, B, and at least two other tables.
To uniquely identify each record in a table.
To help ensure you enter data in the correct table.
To encrypt and decrypt your database.
Complete and accurate.
Duplicated so it's easier to find.
Always backed up.
Merging Table A with Table B.
Linking Table A with Table B.
Adding the primary key from Table A to Table B (or vice-versa).
One, with many fields.
many as necessary to capture all your data without redundancy.