Adding fields to the Arrivals tab view

Adding fields to other tab views is similar to adding the column in the Rack view (covered in the previous topic).  The only difference is that a different Base Table is needed -- for the Transactions tab view the base table of the added Query must be Transactions, and for all other tab views like the Arrivals tab it must be Reservations.

Here is an example of adding the Paid-Thru date to the Arrivals tab view.

1. Go to Maintenance /Advanced Customizations / Queries.

2. Click Add Query, and select List Query.

3. Enter a name, such as "Arrivals Extra"

4. Select "Reservations" for the Base table.

5. Click "Quick-Add Fields"

6. Select the "Paid Thru" field in the Data Field column, and click the left-arrow button (or you can just double-click the Paid Thru field).  You should see it appear under Fields Selected as "Reservations:Resv_Paid_Thru".  You can add as many extra fields as you want to see.  Note: If you were adding a Customer field you would select the "Customers" table when quick-adding fields, and of course for Site fields you would select Sites.  

7. Click Done, and you'll see the added field(s) in the Query Columns table.

8. Just to make it neater, select the line in the list ("Paid Thru") and click Edit Column, select "Center" for the Align Text option.  Click Save / Close all the way out of Query Setup.

9. Click the Options button on the Arrivals tab view, and in the list "Query to insert with additional info" select the query name you just added.

Now you should see the extra column at the far right.  If you want more columns, just edit the Query to add additional fields.  While there isn't a way to insert columns to a specific place, you can achieve the same thing by removing some of the checked "Fields to show" under the Options and just include them in your query instead.