Subform wants to connect to a deleted table

Bobp3114

Member
Local time
Today, 18:22
Joined
Nov 11, 2020
Messages
48
I have a form with three subforms. all is well except for recent entries in subform frmContactDetailsSubformRF, linked by StationID that says..."you cannot add or change a record because a related record is required in table "tblStationData2".
"tblStationData2" is a table that has been renamed before replacing it with "StationData"
I have rebuilt the subform...no change
There are three main forms similar to this one but covering different sections of business....all are effected!
There has been considerable changes in the database to cover recent changes in freight etc.
Image1.jpg
 

Attachments

  • Image1.jpg
    Image1.jpg
    166.7 KB · Views: 1
maybe the foreign key of this table has been "orphaned" due to your changes.
if you will need major changes, make a Backup first so if any thing goes wrong, like this one,
you can revert to the backup.
 
What do you men "orphaned/ How to fix?
 
rebuild your relationship object.
 

Users who are viewing this thread

Back
Top Bottom