list box & update

I have a problem like this. I created a login page. After the user logging in to update their information, and he/she already has data in the database. I created a list box contains all property type. I wanted to show the owner's property type in the list box. If he/she wanted to change the property type, they will click on down arrow to select other one. Otherwise, just leave it the way it was. I have trouble if the user wants to leave the way it was. I can show the property type of that owner's property (in the database already), however, the second update page doesn't allow the user to keep the way it was and display an error message. "You cannot add or change a record because a related record is required in table 'property_type'.
Here is the code:
<cfselect query="listall_propertytype" name="typeid" display="type" value="typeid" required="yes">
<option value="#showpropertytype_inrecord.typeid#" selected><cfoutput>#showpropertytype_inrecord.type#</cfoutput></option></cfselect>

The next page will go through smoothly if the user change the property type ; otherwise it will display an error message.
Does anyone know how to do? Thanks

There is a referential integrity constraint between your first table and the property_type table. It seems to be set up such that you must have a related value in property_type before you can insert or modify a record in your first table. So you'll need to have a record in property_type before you can perform your insert or update.

Hi, here is the relationship of the two tables
propertytype one to many to property table. In propertytype table there is a field named typeid, and property table has that field also. When I update
<cfquery datasource="datasource_name">
update property
set typeid = #form.typeid#
where propertyid = #form.propertyid#
</cfquery>
My problem is when user doesn't want to update which means to keep what the property type already was in property table, the error was shown "You cannot add or change a record because a related record is required in table 'propertytype'"
How can I get around?
Thanks