I have a tabinthe modeltable"technical caract." (TableB), Iwould like to displaythe type ofcars("Sport,CC,Classic....), the fieldshould display the value(text)of the carthereand at the same Time Icanthroughthis fieldto modify or adda newtype ofcar,well,the field should displaythe values relatedtoanother table"A"and store thevalueentered inthetable"B"!the problemthat I havebeen able tobothfeaturesat the same timeinsamefield, soI found asolutionwhich is notsatisfactoryat all,maketwosimilar fields, Type_A and TYpe_B; thefirstshows the valuespresentin thetableabove appearingin a drop down lmist from table "A",and thesecondfield to addor modify valuesin all tablesandfromthe samedrop-down list, except thatthesecondfieldaffichedalvaluesusinga tableintermediate "C"between table AandB.When I Add a record in table"A",the field in the layout of table "B",who show records from table"C" (Type_Cars) will be empty,But that one how show records from table "A" and that I can't Modify it ,Display values.!!!! Can I have a solution ?? Can I make a script that allow me to join the 2 fields at ONE ??