Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Create a new table to capture the details for each sale. The first field should be an AutoNumber field named: SaleDetailID The second field should
Create a new table to capture the details for each sale.
The first field should be an AutoNumber field named: SaleDetailID
The second field should be a lookup field named: SaleID The lookup field should be limited to values in the SaleID field of the Sales table. Include only the SaleID in the lookup field. Enable data integrity by restricting deletions.
Save the table as: SaleDetails
Add a third field to the far right of the table. Name this field: Item This is another lookup field. Include all the fields from the Items table. Sort the lookup items by values in the ItemName field. Hide the primary key field. Enable data integrity by restricting deletions.
Add a Number field to the right of the Item field. Name the field: Quantity
Set the default value for the Quantity field to:
Add three records to the table with the following data. Hint: Remember, the first field in the table, SaleDetailID, is an AutoNumber field, so there is nothing to enter for each record.
SaleID
Item
Quantity
Chocolate
Old Bay
Truffle
Close the table.
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started