from design view, change the data type for the residenceassignment field to use a lookup list. the values in the list should include residencename from the residencehalls table. items in the list should sort alphabetically by the residencename field. allow access to hide the key column. enforce data integrity, and do not allow deletions that would violate the integrity of records. save the table.