Saving records on Form (1 Viewer)

[Sheila.deJesus]

I have 4 tables with the following fields:

Table1 - CustID, customer information....
Table2 - CustID, VehicleID, vehicle information....
Table3 - VehicleID, PolicyID, policy number information
Table4 - PolicyID, premium collection information

The bold/underlined fields are my primary keys in the Relationship.

Everything works well, except for Table4!!! All the records encoded in it can not be saved.

 

[Rich]

PolicyID in table 4 is the ForeignKey and not the PK, you need to add a different PK to table4

 

[Sheila.deJesus]

Thank you very much for your inputs Rich!!!

 

[Sheila.deJesus]

Hi Rich!

I tried adding another field and make it as my PK on Table4. But still the records can't be saved.

Is it your birthday today? If it is.. "Happy Birthday!!!"

Sheila

 

[Rich]

What's the join between tables 3 and 4 ?

 

[Oldsoftboss]

Because these are cascading tables, you must have data in tables 1, 2 and 3 first

 

[Sheila.deJesus]

The join in 3 and 4 is PolicyID. I did have data in tables 1, 2 and 3. I hope the attached Relationship would help.