Operation =1
Option =0
Where ="(((tbl_ad.verkaeufertyp)=2) AND ((tbl_ad.AD) Not Like \"Solar*\" And (tbl_ad.AD)"
    " Not Like \"*SV*\" And (tbl_ad.AD) Not Like \"Reise*\"))"
Begin InputTables
    Name ="tbl_ad"
    Name ="tbl_mepfirma"
    Name ="tbl_verkaufteam_vet"
    Name ="qry_VET"
End
Begin OutputColumns
    Alias ="Name, Vorname"
    Expression ="[Name] & \", \" & [Vorname]"
    Expression ="tbl_mepfirma.id_mepfirma"
    Expression ="tbl_mepfirma.name_mef"
    Expression ="tbl_ad.verkaeufertyp"
    Expression ="tbl_ad.Vorname"
    Expression ="tbl_ad.Name"
    Expression ="tbl_ad.WirdTerminiert"
    Expression ="tbl_ad.ist_taetig"
    Expression ="tbl_ad.taetig_von"
    Expression ="tbl_ad.taetig_bis"
    Expression ="tbl_ad.AD"
    Expression ="tbl_ad.id_verkaufteam"
    Expression ="tbl_verkaufteam_vet.name_vet"
    Expression ="qry_VET.AD_TL"
    Expression ="qry_VET.Vorname_TL"
End
Begin Joins
    LeftTable ="tbl_ad"
    RightTable ="tbl_mepfirma"
    Expression ="tbl_ad.id_mepfirma = tbl_mepfirma.id_mepfirma"
    Flag =1
    LeftTable ="tbl_ad"
    RightTable ="tbl_verkaufteam_vet"
    Expression ="tbl_ad.id_verkaufteam = tbl_verkaufteam_vet.id_verkaufteam"
    Flag =2
    LeftTable ="tbl_verkaufteam_vet"
    RightTable ="qry_VET"
    Expression ="tbl_verkaufteam_vet.idad_teamleiter = qry_VET.ID"
    Flag =2
End
dbBoolean "ReturnsRecords" ="-1"
dbInteger "ODBCTimeout" ="60"
dbByte "RecordsetType" ="0"
dbBoolean "OrderByOn" ="0"
dbByte "Orientation" ="0"
dbByte "DefaultView" ="2"
dbMemo "Filter" ="((EXMepFirma.name_mef=\"MEP West\"))"
dbMemo "OrderBy" ="EXMepFirma.name_vet"
Begin
    Begin
        dbText "Name" ="tbl_ad.AD"
        dbInteger "ColumnWidth" ="2430"
        dbBoolean "ColumnHidden" ="0"
    End
    Begin
        dbText "Name" ="tbl_ad.taetig_bis"
        dbInteger "ColumnWidth" ="1140"
        dbBoolean "ColumnHidden" ="0"
    End
    Begin
        dbText "Name" ="tbl_ad.taetig_von"
        dbInteger "ColumnWidth" ="1140"
        dbBoolean "ColumnHidden" ="0"
    End
    Begin
        dbText "Name" ="Name, Vorname"
        dbInteger "ColumnWidth" ="2295"
        dbBoolean "ColumnHidden" ="0"
    End
    Begin
        dbText "Name" ="tbl_verkaufteam_vet.name_vet"
        dbInteger "ColumnWidth" ="3300"
        dbBoolean "ColumnHidden" ="0"
    End
End
Begin
    State =2
    Left =-6
    Top =-27
    Right =3442
    Bottom =1222
    Left =-1
    Top =-1
    Right =3433
    Bottom =147
    Left =0
    Top =23
    ColumnsShown =539
    Begin
        Left =38
        Top =-17
        Right =134
        Bottom =92
        Top =40
        Name ="tbl_ad"
        Name =""
    End
    Begin
        Left =288
        Top =-9
        Right =384
        Bottom =70
        Top =0
        Name ="tbl_mepfirma"
        Name =""
    End
    Begin
        Left =657
        Top =-9
        Right =1029
        Bottom =100
        Top =0
        Name ="tbl_verkaufteam_vet"
        Name =""
    End
    Begin
        Left =1314
        Top =6
        Right =1410
        Bottom =115
        Top =0
        Name ="qry_VET"
        Name =""
    End
End
