Step $1\mathrm{.}4-$Create the TICKET Table

You will now need to create the TICKET table by repeating the prior steps while referring to the TICKET table definition and the following instructions. Name your table as TICKET when saving.

Make sure the ticket$\_$No field is set to the AutoNumber and designate this field as the primary key.

The seat$\_$ID$,$ pax$\_$ID$,$ and flight$\_$No fields in this table require special attention as these will be the foreign keys used to form relationships between the tables. You will need to use the Lookup Wizard to configure these foreign key fields as outlined below:

$3\mathrm{.}1.$ In the Design View of the TICKET table, create a field named seat$\_$ID$.$ For the Data Type, select Lookup Wizard from the drop$-$down options.

$3\mathrm{.}2.$ In the Lookup Wizard popup, select "I want the lookup field to get the values from another table or query" and click Next.

$3\mathrm{.}3.$ Choose the SEAT table from the list of tables and click Next.

$3\mathrm{.}4.$ Select the seat$\_$ID$,$ seat$\_$No$,$ seat$\_$Type, and plane$\_$Tail fields as your Selected Fields and click Next.

$3\mathrm{.}5.$ Uncheck the Hide Key Column checkbox and resize the lookup columns so the field headers are visible. Click Next.

$3\mathrm{.}6.$ Select seat$\_$ID as the field value for storage in the TICKET table and click Next.

$3\mathrm{.}7.$ Confirm the name of the new field is "seat ID$"$ and click Finish.

Following the prior sequence of steps should produce a new field in the TICKET table such that every time a new record is being added, a drop$-$down menu appears with information being fetched from the SEAT table. Once a seat on a plane is selected, its seat$\_$ID will appear as the field value.

$3\mathrm{.}8.$ Repeat the steps above to create the pax$\_$ID and flight$\_$No fields in the TICKET table. These fields should be based on lookups from the TICKETS table. For pax$\_$ID: display pax$\_$ID$,$ pax$\_$Full$\_$Name, and pax$\_$Tier in the dropdown but only store pax$\_$ID$.$ For flight$\_$No: display all fields in the FLIGHT table but only store flight$\_$No$.$

$4.$ After creating all your fields, you can change the order in which the fields appear in the table. You can do so by opening the table in Design View and dragging the fields up or down. Re$-$arrange the table. fields according to the order they appear in the TICKET table definition,

By using the Lookup Wizard in the TICKET table, we have already started to create relationships among the PASSENGER, FLIGHT, and SEAT tables. Next, we will verify and refine these relationships.

Step $1\mathrm{.}5-$ Populate the TICKET Table

Add $10$ different different to your newly created TICKET table, making up the dates. Create multiple tickets where you are the passenger.