Ok. So this is new. I have an items table that stores information about items my warehouse has in stock. I haven't changed anything on this database in more than a week. I have the items table connected by item id to request details table. That is connected by request id to supply request table. I have a portal to the request details table on my supply request layout so I can enter the details of orders straight from there. Pretty standard ordering set up, right? I thought so. It's been working great for over a year.

Yesterday when I tried to enter one of the items (out of almost 4,000 which work perfectly fine)into my order details portal, it gave me this error:

"This operation cannot be performed because one or more required related records are not available and cannot be created."

After it gives me the error it kills my connection to the server I'm working off of too. I have been using this system for over a year and never had this problem before. Today I noticed that it happened with a second item, but it is still only with those two (as far as I can tell).

My relationships graph seems fine (I haven't changed it, these items worked before), I can access the two items fine in my items table, and even put them into my purchase order order details table easy as pie. I can't figure out what the problem is for the life of me. Any ideas?

Thanks in advance.

Is this a hosted file?

Make sure your hosted files are not shared outside of FMS or that any other process (backup, indexing,..) is touching them.