Open the Performance query in Design view (right-click the query in the Navigation Pane, and select Design View). Add the newly imported Titles table to the query window. Drag and drop the Title field from the Titles table over the Performance field in the query design grid so that it is placed to the left of the Performance field. The query calculates raises for the employees based on data in the Titles table.

Hi, the data that is populating the Supplier Field is from this string object in bold that is one of this variable parameters:  var supplierField = form.addField('custpage_supplier', 'select', 'Supplier', 'customrecord_reorder_suppliers').setLayoutType('startrow');   How do I go about retrieving the suppliers name and reordering the name view from this internal ID 'customrecord_reorder_suppliers'. This ID/string object is to a custom table in NetSuite that houses the supplier information. *Please see screenshot of suppliers table*   I have tried: var supplierName = 'customrecord_reorder_suppliers'.toString().split(' ').reverse().join(' ');. To reassign that string object so I could call it in a function but it still did not work.    If needed we can get on a chat to discuss this in more detail. Please let me know.

I am working on Task 7. Task 7: Create a view named MONTHLY_RENTS. It consists of three columns: the first is the number of bedrooms, the second is the average square feet, and the third is the average monthly rent for all properties in the PROPERTY table that have that number of bedrooms. Use BEDROOMS, AVG_SQUARE_FEET, and AVG_MONTHLY_RENT as the column names. Group and order the rows by number of bedrooms. Here is Tasks 1-7 and what I wrote for Task 8. When I input Task 8, I am not getting results at all.   Expected Results Tables_in_StayWell Table_type MONTHLY_RENTS VIEW

1. Use Design view to create a new table. Add AccountType as the first field name, with data type Short Text and field size 10. Ensure AccountType is set as the primary key. Save the table and name it AccountTypes. Add three records: Platinum, Silver, and Gold. Close the table.2.Open the Customers table in Design view. Set the PhoneNumber and AccountType fields to Required. Save the table. Close the table.3.Open the Loans table in Design view. Establish a validation rule for the InterestRate field that requires the value to be greater than or equal to 2.5 but less than or equal to 10. Create validation text for the InterestRate: Value must be between 2.5 and 10 (no period). Save the table. Change the InterestRate in the first record to 2. The validation text appears. Press ESC to restore the original value. Close the Loans table.4.Open the Customers table in Design view. Add a phone number input mask for the PhoneNumber field, storing the symbols with the data.5.Change the Data Type of…