insert with referential constraints

A person in our office is attempting to access a table, say table A, which has referential constraints to another table (table B). An insert is done on Table B, and then Table A is accessed, and the following error occasionaly occurs: -691 Missing key in referenced table for referential constraint "name". Is it posssible that Table B hasn't been updated with the new information from the insert by the time Table A is accessed? If it is, what can be done to ensure that Table B is fully updated before Table A is accessed? We are running Online 5.03 on an HP 735 with HP-UX 9.05. ------------------------------------------------------------------------- Randy Hills Office of Hydrology - NOHRSC rhills@nohrsc.nws.gov National Weather Service, NOAA voice: (612)361-6610(ext.231) 1735 Lake Drive West fax: (612)361-6634 Chanhassen, Minnesota 55317-8582 http://www.nohrsc.nws.gov -------------------------------------------------------------------------