I have two FM files, each with hundreds of records.
File A has a look up function to file B.
I accidently severed the link and now there are no records in file A. I eliminated "Inventory Total 2" from the relationship you see on the attachement.
While the file, Inventory Total is still 1.1GB, there are no more records. Additionally, when I try to create a new record, none of my fields appear.
When I change to The Layout mode, all of the fields say "Table Missing".
I need to know if I can restore the records. I need to know what happened.
Attached is a screen shot of:
1. Screen Shot of Relationship before incident