Help!! Field changes on it's own!!!!
I have a Job (JobID) which has one or more Presentations (PresentationID). Each Presentation has many items (PresentationItemID). For some reason the PresentationItem associated with the Presentation will change it's PresentationID on it's own, associating itself with another Presentation on another Job. I can go in and change the PresentationID on the PresentationItem back to the correct ID number but it will change itself again. I've never had a problem like this before and I have no idea how it is changing the field like that. It will usually only do it for 1 wrong item at a time but I can't give presentations with wrong or missing item and I can't go in and change the ID's all the time. Help!! What is going on???