My form is based on a query of two different tables. One table is a general info table. This table is related to several process tables by the part number field. The problem is that when I type in the part number on the form it doesn't store the part number in both tables. I tried enforcing referencial integrity but I can't get it to work. Any help would be appreciated.

Thanks,
Laura