can someone please help with this one i know how to do but it keep rejecting the Lookup Wizard. in the end its goes Number data type after i did everything. i will post it how i did it as well.

22. Open the Members table in Design View and complete the following tasks: a. Add a field with the name Status to the end of the table. b. Select Lookup Wizard as the data type. c. Select the option to type in your own values. d. Type in the following two values (in the order shown) as the list of possible values for the field: New and Renewal. Limit the field values to only the items in the list, and do not allow multiple values for the field. Save the changes to the table and then close it. This neard ceates a bolsp feld, which deplors a hut of values you can doose from. How do you want you lookip fidit to get its valuet? f wint the bodup fidd to get the values from mother balle or query. I wit tipen the yoives that f want, What values do you want to see in your loolap field? Enter the number of colums you want in the int, and therr type the values you want in each cel. To adjust the width of a column, drag its right edge to the width you want, or doutle-dick the right edge of the column heading to get the best fit. What labed would you the for veur lockup lield? Staten Do you want to leit entries to the chocess) - Hirut Totiet Do you want to stare mutscie vilues for this bodap? Mow Multiole Valres those are at the andwers the wirad necds to geate your bolup firli. \begin{tabular}{l|l} \hline Field Name & \multicolumn{1}{c}{ Data Type } \\ \hline Memberid & Short Text \\ \hline LastName & Short Text \\ FirstName & Short Text \\ \hline Street & Short Text \\ City & Short Text \\ State & Short Text \\ PostalCode & Short Text \\ MemTypelD & Short Text \\ Mobile & Short Text \\ Status & Number \\ \hline \end{tabular}