no se como restringir entrada de datos

[gralf]

vaya pues debe ser un error mio, si que exporta las fk, ya lo tengo arreglado

Código MySQL:

-- phpMyAdmin SQL Dump
-- version 2.10.3
-- http://www.phpmyadmin.net
-- 
-- Host: localhost
-- Generation Time: Dec 12, 2014 at 01:21 PM
-- Server version: 5.5.28
-- PHP Version: 5.3.26
 
SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";
 
-- 
-- Database: `stocklentesbrujuleando3`
-- 
 
-- --------------------------------------------------------
 
-- 
-- Table structure for table `cilindro`
-- 
 
CREATE TABLE `cilindro` (
  `id_cil` int(2) NOT NULL AUTO_INCREMENT,
  `cilindro` decimal(5,2) NOT NULL,
  PRIMARY KEY (`id_cil`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=18 ;
 
-- --------------------------------------------------------
 
-- 
-- Table structure for table `esfera`
-- 
 
CREATE TABLE `esfera` (
  `id_esf` int(5) NOT NULL AUTO_INCREMENT,
  `esfera` decimal(5,2) NOT NULL,
  PRIMARY KEY (`id_esf`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=75 ;
 
-- --------------------------------------------------------
 
-- 
-- Table structure for table `item`
-- 
 
CREATE TABLE `item` (
  `id_item` int(5) NOT NULL AUTO_INCREMENT,
  `id_rx` int(2) NOT NULL,
  `id_lente` int(2) NOT NULL,
  `movimiento_id_mov` int(5) unsigned DEFAULT NULL,
  PRIMARY KEY (`id_item`),
  KEY `fk_item_lentes1_idx` (`id_lente`),
  KEY `fk_item_rx1_idx` (`id_rx`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=3674 ;
 
-- --------------------------------------------------------
 
-- 
-- Table structure for table `lentes`
-- 
 
CREATE TABLE `lentes` (
  `id_lente` int(2) NOT NULL AUTO_INCREMENT,
  `lente` varchar(25) NOT NULL,
  `desc` varchar(45) NOT NULL,
  `Abbe` int(2) NOT NULL,
  `densidad` varchar(15) NOT NULL,
  `geometría` varchar(15) NOT NULL,
  `id_item` int(5) NOT NULL,
  PRIMARY KEY (`id_lente`),
  UNIQUE KEY `tipo` (`lente`),
  KEY `fk_lentes_item_idx` (`id_item`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=12 ;
 
-- --------------------------------------------------------
 
-- 
-- Table structure for table `movimiento`
-- 
 
CREATE TABLE `movimiento` (
  `id_mov` int(5) unsigned NOT NULL AUTO_INCREMENT,
  `venta` int(5) unsigned DEFAULT NULL,
  `compra` int(5) unsigned DEFAULT NULL,
  `taller` int(5) unsigned DEFAULT NULL,
  `regula_mas` int(5) unsigned DEFAULT NULL,
  `regula_menos` int(5) unsigned DEFAULT NULL,
  `fecha` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `id_item` int(5) NOT NULL,
  `id_lente` int(2) DEFAULT NULL,
  `id_cilindro` int(2) DEFAULT NULL,
  `id_esfera` int(5) DEFAULT NULL,
  PRIMARY KEY (`id_mov`),
  KEY `fk_movimiento_cilindro1_idx` (`id_cilindro`),
  KEY `fk_movimiento_esfera1_idx` (`id_esfera`),
  KEY `fk_movimiento_lentes1` (`id_lente`),
  KEY `fk_salida_item1_idx` (`id_item`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=4 ;
 
-- --------------------------------------------------------
 
-- 
-- Table structure for table `rx`
-- 
 
CREATE TABLE `rx` (
  `Id_rx` int(2) NOT NULL AUTO_INCREMENT,
  `id_cil` int(2) NOT NULL,
  `id_esf` int(5) NOT NULL,
  PRIMARY KEY (`Id_rx`),
  KEY `fk_rx_cilindro1_idx` (`id_cil`),
  KEY `fk_rx_esfera1_idx` (`id_esf`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=2344 ;
 
-- 
-- Constraints for dumped tables
-- 
 
-- 
-- Constraints for table `item`
-- 
ALTER TABLE `item`
  ADD CONSTRAINT `fk_item_lentes1` FOREIGN KEY (`id_lente`) REFERENCES `lentes` (`id_lente`) ON DELETE NO ACTION ON UPDATE NO ACTION,
  ADD CONSTRAINT `fk_item_rx1` FOREIGN KEY (`id_rx`) REFERENCES `rx` (`Id_rx`) ON DELETE NO ACTION ON UPDATE NO ACTION;
 
-- 
-- Constraints for table `movimiento`
-- 
ALTER TABLE `movimiento`
  ADD CONSTRAINT `fk_movimiento_cilindro1` FOREIGN KEY (`id_cilindro`) REFERENCES `cilindro` (`id_cil`) ON DELETE NO ACTION ON UPDATE NO ACTION,
  ADD CONSTRAINT `fk_movimiento_esfera1` FOREIGN KEY (`id_esfera`) REFERENCES `esfera` (`id_esf`) ON DELETE NO ACTION ON UPDATE NO ACTION,
  ADD CONSTRAINT `fk_movimiento_lentes1` FOREIGN KEY (`id_lente`) REFERENCES `lentes` (`id_lente`) ON DELETE NO ACTION ON UPDATE NO ACTION;
 
-- 
-- Constraints for table `rx`
-- 
ALTER TABLE `rx`
  ADD CONSTRAINT `fk_rx_cilindro1` FOREIGN KEY (`id_cil`) REFERENCES `cilindro` (`id_cil`) ON DELETE NO ACTION ON UPDATE NO ACTION,
  ADD CONSTRAINT `fk_rx_esfera1` FOREIGN KEY (`id_esf`) REFERENCES `esfera` (`id_esf`) ON DELETE NO ACTION ON UPDATE NO ACTION;
 

pero sigo pudiendo meter un movimiento.id_item 4000 y este id no existe en la tabla item