Steve is trying to create a lookup field for a field titled “curItemPrice” in related tables. Steve opens one of the tables and examines “curItemPrice” in Design view. He clicks in the Data Type column for “curItemPrice” and tries to change the data type from Currency to Lookup Wizard. An error message is displayed on the computer screen stating that the data type or field size cannot be changed. What is the most likely reason for this error message? Steve did not choose the correct data type for the field.
Steve did not open both tables before changing the data type.
Steve did not delete the relationship between the tables.
Steve did not sort the records in the tables before opening Design