I have over 500 contracts with the primary key being the contract number. While not needed previously, I now have been asked to create a table showing different payments made under each contract. Some may have only 1 type of payment and others as many as 5. My payment table will have a row for each contract number and a column for each payment type. The common key in each table will be the contract number.
I don't want to have to type each contract number into the new "payments" table. If I cut and paste and then enforce referential integrity (assuming I can) will:
1. Changes in data to 1 table make changes to the other?, and;
2. If I add a new contract to one table will it also be added to the other table?
Thanks in advance!