Gabi, your new record was probably created via the relation diagram. Click on he connection line, the popup that opens has a checkmark to create new records. Turn this off.
thanks for your answer. It actually works but it does not do what i would like it to do. Doing what you suggested yes it lets me select from the list without creating new record but.....
Basically the Layout for table Contact has several fields borrowed from table Company. Such as Company name and Company address. By selecting a value for Company Name along with tha it should populate the Company address field too. I know it is possible and it actually should work but it doesnt. It only works if i put a value in the Company Name foreign key field but i would like to make the same effect using only the Company name.
How can i do that?