I havent changed anything but suddenly the table relation is only working in one direction. Can anyone help me?!
Wait, its even worst than that. Some records are relating but others aren't.
Turn off indexing on the fields in the relationship, save the changes, then turn indexing back on.
Based on your other issue with external files being prompted for, I'd suggest that you might be better off trying the conversion from v11 again.
Thanks. I am trying the indexing thing now. this database would not convert properly so i completely rebuilt in 12.
Database or temporary file "Coupon DB" is damaged and has been closed. (20401 : 38 : 1768450670)
Bad news for me. The server closed it and the log stated that.
Do you have a backup or clone from before the problem occured? ( I hope...)
Retrieving data ...