I've built the following tables (see below) with the indicated relationships. The problem occurs when I try to create a Form for data entry. The Form either shows up blank in Form View, or it won't allow me to input data into it. The data types for the primary key and related tbl match. The record source for my Form is a query that consists of every field from the tables below. Please Help.
TBL_PROD
Prod_ID (Primary Key & relates to TBL_CONTRACT)
Prod_Contact
Prod_CO_Name
Prod_Address
... (City, State, Zip)
TBL_CLIENT
Client_ID (Primary Key & relates to TBL_CONTRACT)
Client_Name
Client_Address
... (City, State, Zip)
TBL_THIRD_Party
TP_ID (Primary Key & relates to TBL_CONTRACT)
TP_CO_Name
TP_Address
... (City, State, Zip)
TBL_CONTRACT
Contract_ID (Primary Key)
Client_ID (Relationship w/ TBL_CLIENT)
Prod_ID (Relationship w/ TBL_Prod_
Date_From
Date_To
TP_ID (Relationship w/ TBL_THIRD_PARTY)
Issue_date
TBL_PROD
Prod_ID (Primary Key & relates to TBL_CONTRACT)
Prod_Contact
Prod_CO_Name
Prod_Address
... (City, State, Zip)
TBL_CLIENT
Client_ID (Primary Key & relates to TBL_CONTRACT)
Client_Name
Client_Address
... (City, State, Zip)
TBL_THIRD_Party
TP_ID (Primary Key & relates to TBL_CONTRACT)
TP_CO_Name
TP_Address
... (City, State, Zip)
TBL_CONTRACT
Contract_ID (Primary Key)
Client_ID (Relationship w/ TBL_CLIENT)
Prod_ID (Relationship w/ TBL_Prod_
Date_From
Date_To
TP_ID (Relationship w/ TBL_THIRD_PARTY)
Issue_date
