APRLIST ver1-8 : MACRO LIST FOR APR FILE NAME: C:\Aprdump\aussie\tugalong\tugalong.apr
 
DATE: 7/30/2020                                            TIME: 10:43:36 AM
--------------------------------------------------------------------------------
 
 
 
 
 
-------------------------------------------------------------------------------
                              J O I N S 
-------------------------------------------------------------------------------
Relational options (Rel Optns)
  ADD-If no matching records in joined file, adding a record in this file
      also adds a record in the joined file
  DEL-Deleting a record in this file deletes matching records in joined file
 
 
001  Join File  tugalong                         to ROB                             
     Rel Optns  ADD                                 ADD                             
     Join Key   TugalongID                      ->  TUGID                           
 
002  Join File  Rooms                            to ROB                             
     Rel Optns  ADD                                 ADD                             
     Join Key   RoomNo                          ->  RoomID                          
 
----------------------------------------------------------------------------------------
                                     Named Finds                           
----------------------------------------------------------------------------------------
             ***   use APPROACH IDE to check DUPS/DISTINCT or Qry by BOX   ***
----------------------------------------------------------------------------------------
 
Find#:   1 TYPE :VIEW  -> NAME: Cleaining List                            on: Worksheet 3
           condx #1: Rooms.booked BEGINS WITH 1
 
 
Find#:   2 TYPE :VIEW  -> NAME: Cleaning done                             on: Worksheet 1
           condx #1: Rooms.booked BEGINS WITH 1
 
 
Find#:   3 TYPE :VIEW  -> NAME: datefind                                  on: Worksheet 2
           condx #1: tugalong.DateTo LESS or EQ  the value in FINDDATEVAR2 AND
                   : tugalong.Meals EQUAL TRUE
        OR condx #2: tugalong.DateFrom EQ or GTR  the value in FINDDATEVAR2 AND
                   : tugalong.Meals EQUAL TRUE
 
 
Find#:   4 TYPE :VIEW  -> NAME: Room Cleaning                             on: Worksheet 3
           condx #1: tugalong.DateFrom LESS or EQ  the value in FINDDATEVAR2 AND
                   : tugalong.DateTo EQ or GTR  the value in FINDDATEVAR2
 
 
Find#:   5 TYPE :VIEW  -> NAME: All Current and Future Bookings           on: Worksheet 2
           condx #1: tugalong.DateTo GTR THAN  the value in Today()
 
 
Find#:   6 TYPE :VIEW  -> NAME: Find Current record                       on: Worksheet 2
           condx #1: tugalong.TugalongID EQUAL  the value in FindNumvar1
 
 
Find#:   7 TYPE :VIEW  -> NAME: Find defuntc records                      on: Worksheet 2
           condx #1: tugalong.DateTo LESS THAN  the value in Today()
 
 
Find#:   8 TYPE :VIEW  -> NAME: Activities                                on: Worksheet 2
           condx #1: tugalong.DateFrom LESS or EQ  the value in FINDDATEVAR2 AND
                   : tugalong.DateTo EQ or GTR  the value in FINDDATEVAR2
 
 
Find#:   9 TYPE :VIEW  -> NAME: dailymeals                                on: Worksheet 2
           condx #1: tugalong.DateFrom LESS or EQ  the value in FINDDATEVAR2 AND
                   : tugalong.DateTo EQ or GTR  the value in FINDDATEVAR2
 
 
Find#:  10 TYPE :VIEW  -> NAME: Find Bookings                             on: Worksheet 1
           condx #1: tugalong.DateFrom EQ or GTR  the value in FINDDATEVAR1 
                   : tugalong.DateFrom LESS or EQ  the value in FINDDATEVAR2
        OR condx #2: tugalong.DateTo EQ or GTR  the value in FINDDATEVAR1 
                   : tugalong.DateTo LESS or EQ  the value in FINDDATEVAR2
                   : Rooms.RoomNo GTR THAN 0.000
        OR condx #3: Rooms.RoomNo GTR THAN 0.000
 
 
Find#:  11 TYPE :VIEW  -> NAME: Find a booking                            on: Main Booking details Form
           condx #1: tugalong.Booking Name BEGINS WITH  the value in FindtextVar1
 
 
Find#:  12 TYPE :VIEW  -> NAME: Find vacant rooms                         on: Worksheet 3
           condx #1: Rooms.booked NOT EQUAL 1
 
  
