Hi Sahil,
Here is the verification, dataset and dataschema you requested;
cmSmallint06 <-- the datatypes of the column in both tables?
Here are partial definitions for the tables;
\\
CREATE TABLE [lkp302SensorTyp e] (
[pkSensorTypeId] [smallint] IDENTITY (1, 1) NOT NULL ,
...
//
\\
CREATE TABLE [tbl040Cmpt] (
...
[cmSmallint06] [smallint] NULL ,
...
//
the definition of the datarelation
Here is the relation
\\
Me.Relations.Ad d("Lkp_tbl040Cm pt_lkp302Sensor Type",
Me.Tables("lkp3 02SensorType"). Columns("pkSens orTypeId"),
Me.Tables("tbl0 40Cmpt").Column s("cmSmallint06 "))
//
the fact that "5" exists in the other datatable at the moment you are trying
to add that row.
Here is the data contained in lkp302SensorTyp e in the form of CSV;
\\
pkSensorTypeId, SensorType,Ord, Hide
1,"Bar Code",1,False
2,"Capacitive", 2,False
3,"Color",3,Fal se
4,"Diffuse",4,F alse
5,"Hall Effect",5,False
6,"Inductive",6 ,False
7,"Limit Switch",7,False
8,"Pressure",8, False
9,"Reed",9,Fals e
10,"Retro-Reflective",10, False
11,"Through Beam",11,False
12,"Ultrasonic" ,12,False
//
Here is the dataset;
\\
<?xml version="1.0" standalone="yes "?>
<NewDataSet>
<tbl040Cmpt>
<pkComponentId> 8bf25abb-cb5d-40ec-8e37-2baf565a3cde</pkComponentId>
<fkDevice>9fbbd 7c8-a833-48a1-8036-f2fb5c02a718</fkDevice>
<fkComponentTyp e>2</fkComponentType >
<ComponentDescr iption>Cyl - Clip Driver -
Cyln</ComponentDescri ption>
<QuanSharingCon figuration>4</QuanSharingConf iguration>
<QuanConfigured >4</QuanConfigured>
<QuanActuations >1</QuanActuations>
<cmVarchar04>(s ee valve)</cmVarchar04>
<cmNumeric02>1. 500</cmNumeric02>
<cmNumeric03>2. 000</cmNumeric03>
<cmNumeric04>0. 375</cmNumeric04>
<cmNumeric05>1. 000</cmNumeric05>
<cmNumeric07>3. 162</cmNumeric07>
<cmBit01>fals e</cmBit01>
<cmBit02>fals e</cmBit02>
<cmBit04>true </cmBit04>
<cmBit05>fals e</cmBit05>
<cmBit07>true </cmBit07>
<cmBit08>true </cmBit08>
<cmBit09>fals e</cmBit09>
<cmBit10>true </cmBit10>
<cmSmallint05>1 </cmSmallint05>
<cmTinyint01> 0</cmTinyint01>
<cmUserNote />
<cmCreatedOn>20 05-11-27T16:28:00.000 0000-05:00</cmCreatedOn>
<cmCreatedBy>db uchanan</cmCreatedBy>
<cmEditedOn>200 5-11-27T16:28:00.000 0000-05:00</cmEditedOn>
<cmEditedBy>dbu chanan</cmEditedBy>
<cmrowversion>A AAAAAAAxzI=</cmrowversion>
</tbl040Cmpt>
<lkp101PortSize >
<pkPortSizeId>7 </pkPortSizeId>
<PortSize>1/8 G</PortSize>
<Ord>1</Ord>
<Hide>false</Hide>
</lkp101PortSize>
<lkp101PortSize >
<pkPortSizeId>1 </pkPortSizeId>
<PortSize>1/8 NPT</PortSize>
<Ord>1</Ord>
<Hide>false</Hide>
</lkp101PortSize>
<lkp101PortSize >
<pkPortSizeId>2 </pkPortSizeId>
<PortSize>10-32 Straight</PortSize>
<Ord>2</Ord>
<Hide>false</Hide>
</lkp101PortSize>
<lkp101PortSize >
<pkPortSizeId>8 </pkPortSizeId>
<PortSize>1/4 G</PortSize>
<Ord>3</Ord>
<Hide>false</Hide>
</lkp101PortSize>
<lkp101PortSize >
<pkPortSizeId>3 </pkPortSizeId>
<PortSize>1/4 NPT</PortSize>
<Ord>3</Ord>
<Hide>false</Hide>
</lkp101PortSize>
<lkp101PortSize >
<pkPortSizeId>9 </pkPortSizeId>
<PortSize>3/8 G</PortSize>
<Ord>4</Ord>
<Hide>false</Hide>
</lkp101PortSize>
<lkp101PortSize >
<pkPortSizeId>4 </pkPortSizeId>
<PortSize>3/8 NPT</PortSize>
<Ord>4</Ord>
<Hide>false</Hide>
</lkp101PortSize>
<lkp101PortSize >
<pkPortSizeId>1 0</pkPortSizeId>
<PortSize>1/2 G</PortSize>
<Ord>5</Ord>
<Hide>false</Hide>
</lkp101PortSize>
<lkp101PortSize >
<pkPortSizeId>5 </pkPortSizeId>
<PortSize>1/2 NPT</PortSize>
<Ord>5</Ord>
<Hide>false</Hide>
</lkp101PortSize>
<lkp101PortSize >
<pkPortSizeId>1 1</pkPortSizeId>
<PortSize>3/4 G</PortSize>
<Ord>6</Ord>
<Hide>false</Hide>
</lkp101PortSize>
<lkp101PortSize >
<pkPortSizeId>6 </pkPortSizeId>
<PortSize>3/4 NPT</PortSize>
<Ord>6</Ord>
<Hide>false</Hide>
</lkp101PortSize>
</NewDataSet>
//
Here is the schemafile
\\
<?xml version="1.0" standalone="yes "?>
<xs:schema id="NewDataSet " xmlns=""
xmlns:xs="http://www.w3.org/2001/XMLSchema"
xmlns:msdata="u rn:schemas-microsoft-com:xml-msdata">
<xs:element name="NewDataSe t" msdata:IsDataSe t="true">
<xs:complexType >
<xs:choice maxOccurs="unbo unded">
<xs:element name="tbl010Job ">
<xs:complexType >
<xs:sequence>
<xs:element name="pkJobId" msdata:ReadOnly ="true">
<xs:simpleTyp e>
<xs:restricti on base="xs:string ">
<xs:maxLength value="36" />
</xs:restriction>
</xs:simpleType>
</xs:element>
<xs:element name="JobNumber ">
<xs:simpleTyp e>
<xs:restricti on base="xs:string ">
<xs:maxLength value="7" />
</xs:restriction>
</xs:simpleType>
</xs:element>
<xs:element name="CustomerN ame">
<xs:simpleTyp e>
<xs:restricti on base="xs:string ">
<xs:maxLength value="35" />
</xs:restriction>
</xs:simpleType>
</xs:element>
<xs:element name="JobDescri ption">
<xs:simpleTyp e>
<xs:restricti on base="xs:string ">
<xs:maxLength value="75" />
</xs:restriction>
</xs:simpleType>
</xs:element>
<xs:element name="Reference JobNumber" minOccurs="0">
<xs:simpleTyp e>
<xs:restricti on base="xs:string ">
<xs:maxLength value="7" />
</xs:restriction>
</xs:simpleType>
</xs:element>
<xs:element name="ShopPsi" type="xs:unsign edByte"
minOccurs="0" />
<xs:element name="SystemVol tage" type="xs:short"
minOccurs="0" />
<xs:element name="SystemPha se" type="xs:short"
minOccurs="0" />
<xs:element name="SystemAmp s" minOccurs="0">
<xs:simpleTyp e>
<xs:restricti on base="xs:string ">
<xs:maxLength value="3" />
</xs:restriction>
</xs:simpleType>
</xs:element>
<xs:element name="HasCircui tBreakersYN" type="xs:boolea n"
/>
<xs:element name="AllProces sesAddedYN" type="xs:boolea n"
/>
<xs:element name="AllTasksA ddedYN" type="xs:boolea n" />
<xs:element name="AllProces sesConfiguredYN "
type="xs:boolea n" />
<xs:element name="ApprovedY N" type="xs:boolea n" />
<xs:element name="Completed YN" type="xs:boolea n" />
<xs:element name="IsMasterY N" type="xs:boolea n" />
<xs:element name="Archive" type="xs:boolea n" />
<xs:element name="jcUserNot e">
<xs:simpleTyp e>
<xs:restricti on base="xs:string ">
<xs:maxLength value="100" />
</xs:restriction>
</xs:simpleType>
</xs:element>
<xs:element name="jcCreated On" type="xs:dateTi me" />
<xs:element name="jcCreated By">
<xs:simpleTyp e>
<xs:restricti on base="xs:string ">
<xs:maxLength value="25" />
</xs:restriction>
</xs:simpleType>
</xs:element>
<xs:element name="jcEditedO n" type="xs:dateTi me" />
<xs:element name="jcEditedB y">
<xs:simpleTyp e>
<xs:restricti on base="xs:string ">
<xs:maxLength value="25" />
</xs:restriction>
</xs:simpleType>
</xs:element>
<xs:element name="jcrowvers ion" type="xs:base64 Binary"
minOccurs="0" />
</xs:sequence>
</xs:complexType>
</xs:element>
<xs:element name="tbl020Pro c">
<xs:complexType >
<xs:sequence>
<xs:element name="pkProcess Id" msdata:ReadOnly ="true">
<xs:simpleTyp e>
<xs:restricti on base="xs:string ">
<xs:maxLength value="36" />
</xs:restriction>
</xs:simpleType>
</xs:element>
<xs:element name="fkJob">
<xs:simpleTyp e>
<xs:restricti on base="xs:string ">
<xs:maxLength value="36" />
</xs:restriction>
</xs:simpleType>
</xs:element>
<xs:element name="fkDeviceT ype" type="xs:int" />
<xs:element name="QuanIndiv idualProcesses"
type="xs:unsign edByte" />
<xs:element name="QuanIndiv idualProcessesC onfigured"
type="xs:unsign edByte" />
<xs:element name="mpUserNot e">
<xs:simpleTyp e>
<xs:restricti on base="xs:string ">
<xs:maxLength value="100" />
</xs:restriction>
</xs:simpleType>
</xs:element>
<xs:element name="mpCreated On" type="xs:dateTi me" />
<xs:element name="mpCreated By">
<xs:simpleTyp e>
<xs:restricti on base="xs:string ">
<xs:maxLength value="25" />
</xs:restriction>
</xs:simpleType>
</xs:element>
<xs:element name="mpEditedO n" type="xs:dateTi me" />
<xs:element name="mpEditedB y">
<xs:simpleTyp e>
<xs:restricti on base="xs:string ">
<xs:maxLength value="25" />
</xs:restriction>
</xs:simpleType>
</xs:element>
<xs:element name="mprowvers ion" type="xs:base64 Binary"
minOccurs="0" />
</xs:sequence>
</xs:complexType>
</xs:element>
<xs:element name="tbl030Dev i">
<xs:complexType >
<xs:sequence>
<xs:element name="pkDeviceI d" msdata:ReadOnly ="true">
<xs:simpleTyp e>
<xs:restricti on base="xs:string ">
<xs:maxLength value="36" />
</xs:restriction>
</xs:simpleType>
</xs:element>
<xs:element name="fkProcess ">
<xs:simpleTyp e>
<xs:restricti on base="xs:string ">
<xs:maxLength value="36" />
</xs:restriction>
</xs:simpleType>
</xs:element>
<xs:element name="DeviceDes cription">
<xs:simpleTyp e>
<xs:restricti on base="xs:string ">
<xs:maxLength value="50" />
</xs:restriction>
</xs:simpleType>
</xs:element>
<xs:element name="QuanOfAct uations"
type="xs:unsign edByte" />
<xs:element name="CustomDev iceYN" type="xs:boolea n" />
<xs:element name="QuanCylin ders" type="xs:unsign edByte"
/>
<xs:element name="QuanValve s" type="xs:unsign edByte" />
<xs:element name="QuanSenso rs" type="xs:unsign edByte" />
<xs:element name="QuanAirSe rvices" type="xs:unsign edByte"
/>
<xs:element name="QuanElect Services"
type="xs:unsign edByte" />
<xs:element name="QuanHMIs" type="xs:unsign edByte" />
<xs:element name="QuanCylin dersConfigured"
type="xs:unsign edByte" />
<xs:element name="QuanValve sConfigured"
type="xs:unsign edByte" />
<xs:element name="QuanSenso rsConfigured"
type="xs:unsign edByte" />
<xs:element name="QuanAirSe rvicesConfigure d"
type="xs:unsign edByte" />
<xs:element name="QuanElect ServicesConfigu red"
type="xs:unsign edByte" />
<xs:element name="QuanHMIsC onfigured"
type="xs:unsign edByte" />
<xs:element name="QuanMotio nSensorsConfigu red"
type="xs:unsign edByte" />
<xs:element name="DeviceCon figCompleteYN"
type="xs:boolea n" />
<xs:element name="dsUserNot e">
<xs:simpleTyp e>
<xs:restricti on base="xs:string ">
<xs:maxLength value="255" />
</xs:restriction>
</xs:simpleType>
</xs:element>
<xs:element name="dsCreated On" type="xs:dateTi me" />
<xs:element name="dsCreated By">
<xs:simpleTyp e>
<xs:restricti on base="xs:string ">
<xs:maxLength value="25" />
</xs:restriction>
</xs:simpleType>
</xs:element>
<xs:element name="dsEditedO n" type="xs:dateTi me" />
<xs:element name="dsEditedB y">
<xs:simpleTyp e>
<xs:restricti on base="xs:string ">
<xs:maxLength value="25" />
</xs:restriction>
</xs:simpleType>
</xs:element>
<xs:element name="dsrowvers ion" type="xs:base64 Binary"
minOccurs="0" />
</xs:sequence>
</xs:complexType>
</xs:element>
<xs:element name="tbl040Cmp t">
<xs:complexType >
<xs:sequence>
<xs:element name="pkCompone ntId" msdata:ReadOnly ="true">
<xs:simpleTyp e>
<xs:restricti on base="xs:string ">
<xs:maxLength value="36" />
</xs:restriction>
</xs:simpleType>
</xs:element>
<xs:element name="fkDevice" >
<xs:simpleTyp e>
<xs:restricti on base="xs:string ">
<xs:maxLength value="36" />
</xs:restriction>
</xs:simpleType>
</xs:element>
<xs:element name="fkCompone ntType" type="xs:int" />
<xs:element name="Component Description">
<xs:simpleTyp e>
<xs:restricti on base="xs:string ">
<xs:maxLength value="100" />
</xs:restriction>
</xs:simpleType>
</xs:element>
<xs:element name="QuanShari ngConfiguration "
type="xs:unsign edByte" />
<xs:element name="QuanConfi gured" type="xs:unsign edByte"
/>
<xs:element name="QuanActua tions" type="xs:unsign edByte"
/>
<xs:element name="cmVarchar 01" minOccurs="0">
<xs:simpleTyp e>
<xs:restricti on base="xs:string ">
<xs:maxLength value="50" />
</xs:restriction>
</xs:simpleType>
</xs:element>
<xs:element name="cmVarchar 02" minOccurs="0">
<xs:simpleTyp e>
<xs:restricti on base="xs:string ">
<xs:maxLength value="50" />
</xs:restriction>
</xs:simpleType>
</xs:element>
<xs:element name="cmVarchar 03" minOccurs="0">
<xs:simpleTyp e>
<xs:restricti on base="xs:string ">
<xs:maxLength value="50" />
</xs:restriction>
</xs:simpleType>
</xs:element>
<xs:element name="cmVarchar 04" minOccurs="0">
<xs:simpleTyp e>
<xs:restricti on base="xs:string ">
<xs:maxLength value="50" />
</xs:restriction>
</xs:simpleType>
</xs:element>
<xs:element name="cmVarchar 05" minOccurs="0">
<xs:simpleTyp e>
<xs:restricti on base="xs:string ">
<xs:maxLength value="50" />
</xs:restriction>
</xs:simpleType>
</xs:element>
<xs:element name="cmVarchar 06" minOccurs="0">
<xs:simpleTyp e>
<xs:restricti on base="xs:string ">
<xs:maxLength value="50" />
</xs:restriction>
</xs:simpleType>
</xs:element>
<xs:element name="cmNumeric 01" type="xs:decima l"
minOccurs="0" />
<xs:element name="cmNumeric 02" type="xs:decima l"
minOccurs="0" />
<xs:element name="cmNumeric 03" type="xs:decima l"
minOccurs="0" />
<xs:element name="cmNumeric 04" type="xs:decima l"
minOccurs="0" />
<xs:element name="cmNumeric 05" type="xs:decima l"
minOccurs="0" />
<xs:element name="cmNumeric 06" type="xs:decima l"
minOccurs="0" />
<xs:element name="cmNumeric 07" type="xs:decima l"
minOccurs="0" />
<xs:element name="cmBit01" type="xs:boolea n"
minOccurs="0" />
<xs:element name="cmBit02" type="xs:boolea n"
minOccurs="0" />
<xs:element name="cmBit03" type="xs:boolea n"
minOccurs="0" />
<xs:element name="cmBit04" type="xs:boolea n"
minOccurs="0" />
<xs:element name="cmBit05" type="xs:boolea n"
minOccurs="0" />
<xs:element name="cmBit06" type="xs:boolea n"
minOccurs="0" />
<xs:element name="cmBit07" type="xs:boolea n"
minOccurs="0" />
<xs:element name="cmBit08" type="xs:boolea n"
minOccurs="0" />
<xs:element name="cmBit09" type="xs:boolea n"
minOccurs="0" />
<xs:element name="cmBit10" type="xs:boolea n"
minOccurs="0" />
<xs:element name="cmBit11" type="xs:boolea n"
minOccurs="0" />
<xs:element name="cmSmallin t01" type="xs:short"
minOccurs="0" />
<xs:element name="cmSmallin t02" type="xs:short"
minOccurs="0" />
<xs:element name="cmSmallin t03" type="xs:short"
minOccurs="0" />
<xs:element name="cmSmallin t04" type="xs:short"
minOccurs="0" />
<xs:element name="cmSmallin t05" type="xs:short"
minOccurs="0" />
<xs:element name="cmSmallin t06" type="xs:short"
minOccurs="0" />
<xs:element name="cmSmallin t07" type="xs:short"
minOccurs="0" />
<xs:element name="cmSmallin t08" type="xs:short"
minOccurs="0" />
<xs:element name="cmTinyint 01" type="xs:short"
minOccurs="0" />
<xs:element name="SooOrder" type="xs:decima l"
minOccurs="0" />
<xs:element name="SooPreced ent" type="xs:decima l"
minOccurs="0" />
<xs:element name="SooDelay" type="xs:decima l"
minOccurs="0" />
<xs:element name="SooNote" minOccurs="0">
<xs:simpleTyp e>
<xs:restricti on base="xs:string ">
<xs:maxLength value="255" />
</xs:restriction>
</xs:simpleType>
</xs:element>
<xs:element name="cmUserNot e">
<xs:simpleTyp e>
<xs:restricti on base="xs:string ">
<xs:maxLength value="255" />
</xs:restriction>
</xs:simpleType>
</xs:element>
<xs:element name="cmCreated On" type="xs:dateTi me" />
<xs:element name="cmCreated By">
<xs:simpleTyp e>
<xs:restricti on base="xs:string ">
<xs:maxLength value="25" />
</xs:restriction>
</xs:simpleType>
</xs:element>
<xs:element name="cmEditedO n" type="xs:dateTi me" />
<xs:element name="cmEditedB y">
<xs:simpleTyp e>
<xs:restricti on base="xs:string ">
<xs:maxLength value="25" />
</xs:restriction>
</xs:simpleType>
</xs:element>
<xs:element name="cmrowvers ion" type="xs:base64 Binary"
minOccurs="0" />
</xs:sequence>
</xs:complexType>
</xs:element>
<xs:element name="tbl050Ope r">
<xs:complexType >
<xs:sequence>
<xs:element name="pkOperId" msdata:ReadOnly ="true">
<xs:simpleTyp e>
<xs:restricti on base="xs:string ">
<xs:maxLength value="36" />
</xs:restriction>
</xs:simpleType>
</xs:element>
<xs:element name="sqfkJob">
<xs:simpleTyp e>
<xs:restricti on base="xs:string ">
<xs:maxLength value="36" />
</xs:restriction>
</xs:simpleType>
</xs:element>
<xs:element name="sqCompone ntDescription">
<xs:simpleTyp e>
<xs:restricti on base="xs:string ">
<xs:maxLength value="100" />
</xs:restriction>
</xs:simpleType>
</xs:element>
<xs:element name="sqAction" minOccurs="0">
<xs:simpleTyp e>
<xs:restricti on base="xs:string ">
<xs:maxLength value="50" />
</xs:restriction>
</xs:simpleType>
</xs:element>
<xs:element name="sqDuratio n" type="xs:decima l"
minOccurs="0" />
<xs:element name="sqSooOrde r" type="xs:decima l"
minOccurs="0" />
<xs:element name="sqSooPrec edent" type="xs:decima l"
minOccurs="0" />
<xs:element name="sqSooDela y" type="xs:decima l"
minOccurs="0" />
<xs:element name="sqIOAddre ss" minOccurs="0">
<xs:simpleTyp e>
<xs:restricti on base="xs:string ">
<xs:maxLength value="50" />
</xs:restriction>
</xs:simpleType>
</xs:element>
<xs:element name="sqSooNote " minOccurs="0">
<xs:simpleTyp e>
<xs:restricti on base="xs:string ">
<xs:maxLength value="255" />
</xs:restriction>
</xs:simpleType>
</xs:element>
<xs:element name="sqCreated On" type="xs:dateTi me" />
<xs:element name="sqCreated By">
<xs:simpleTyp e>
<xs:restricti on base="xs:string ">
<xs:maxLength value="25" />
</xs:restriction>
</xs:simpleType>
</xs:element>
<xs:element name="sqEditedO n" type="xs:dateTi me" />
<xs:element name="sqEditedB y">
<xs:simpleTyp e>
<xs:restricti on base="xs:string ">
<xs:maxLength value="25" />
</xs:restriction>
</xs:simpleType>
</xs:element>
<xs:element name="sqrowvers ion" type="xs:base64 Binary"
minOccurs="0" />
</xs:sequence>
</xs:complexType>
</xs:element>
<xs:element name="tblUnion1 ">
<xs:complexType >
<xs:sequence>
<xs:element name="pkID_u1" msdata:ReadOnly ="true">
<xs:simpleTyp e>
<xs:restricti on base="xs:string ">
<xs:maxLength value="36" />
</xs:restriction>
</xs:simpleType>
</xs:element>
<xs:element name="fkJob_u1" >
<xs:simpleTyp e>
<xs:restricti on base="xs:string ">
<xs:maxLength value="36" />
</xs:restriction>
</xs:simpleType>
</xs:element>
<xs:element name="tbl_u1" type="xs:short" />
<xs:element name="cmptDescr iption_u1">
<xs:simpleTyp e>
<xs:restricti on base="xs:string ">
<xs:maxLength value="100" />
</xs:restriction>
</xs:simpleType>
</xs:element>
<xs:element name="Action_u1 " minOccurs="0">
<xs:simpleTyp e>
<xs:restricti on base="xs:string ">
<xs:maxLength value="50" />
</xs:restriction>
</xs:simpleType>
</xs:element>
<xs:element name="Duration_ u1" type="xs:decima l"
minOccurs="0" />
<xs:element name="Order_u1" type="xs:decima l"
minOccurs="0" />
<xs:element name="Precedent _u1" type="xs:unsign edByte"
minOccurs="0" />
<xs:element name="Delay_u1" minOccurs="0">
<xs:simpleTyp e>
<xs:restricti on base="xs:string ">
<xs:maxLength value="255" />
</xs:restriction>
</xs:simpleType>
</xs:element>
<xs:element name="IOAddress _u1" minOccurs="0">
<xs:simpleTyp e>
<xs:restricti on base="xs:string ">
<xs:maxLength value="50" />
</xs:restriction>
</xs:simpleType>
</xs:element>
<xs:element name="Note_u1" minOccurs="0">
<xs:simpleTyp e>
<xs:restricti on base="xs:string ">
<xs:maxLength value="255" />
</xs:restriction>
</xs:simpleType>
</xs:element>
<xs:element name="CreatedOn _u1" type="xs:dateTi me" />
<xs:element name="CreatedBy _u1">
<xs:simpleTyp e>
<xs:restricti on base="xs:string ">
<xs:maxLength value="25" />
</xs:restriction>
</xs:simpleType>
</xs:element>
<xs:element name="EditedOn_ u1" type="xs:dateTi me" />
<xs:element name="EditedBy_ u1">
<xs:simpleTyp e>
<xs:restricti on base="xs:string ">
<xs:maxLength value="25" />
</xs:restriction>
</xs:simpleType>
</xs:element>
<xs:element name="rowversio n_u1" type="xs:base64 Binary"
minOccurs="0" />
</xs:sequence>
</xs:complexType>
</xs:element>
<xs:element name="tblUseAud it">
<xs:complexType >
<xs:sequence>
<xs:element name="ClipUser" >
<xs:simpleTyp e>
<xs:restricti on base="xs:string ">
<xs:maxLength value="50" />
</xs:restriction>
</xs:simpleType>
</xs:element>
<xs:element name="Computer" minOccurs="0">
<xs:simpleTyp e>
<xs:restricti on base="xs:string ">
<xs:maxLength value="50" />
</xs:restriction>
</xs:simpleType>
</xs:element>
<xs:element name="ClipVersi on">
<xs:simpleTyp e>
<xs:restricti on base="xs:string ">
<xs:maxLength value="50" />
</xs:restriction>
</xs:simpleType>
</xs:element>
<xs:element name="DateTime" type="xs:dateTi me" />
<xs:element name="Selection ">
<xs:simpleTyp e>
<xs:restricti on base="xs:string ">
<xs:maxLength value="50" />
</xs:restriction>
</xs:simpleType>
</xs:element>
</xs:sequence>
</xs:complexType>
</xs:element>
<xs:element name="lst00Mast erList">
<xs:complexType >
<xs:sequence>
<xs:element name="pkMasterL istId" msdata:ReadOnly ="true"
msdata:AutoIncr ement="true" msdata:AutoIncr ementSeed="-1"
msdata:AutoIncr ementStep="-1" type="xs:int" />
<xs:element name="TableName ">
<xs:simpleTyp e>
<xs:restricti on base="xs:string ">
<xs:maxLength value="25" />
</xs:restriction>
</xs:simpleType>
</xs:element>
<xs:element name="FriendlyN ame">
<xs:simpleTyp e>
<xs:restricti on base="xs:string ">
<xs:maxLength value="25" />
</xs:restriction>
</xs:simpleType>
</xs:element>
<xs:element name="UserInstr uction" minOccurs="0">
<xs:simpleTyp e>
<xs:restricti on base="xs:string ">
<xs:maxLength value="255" />
</xs:restriction>
</xs:simpleType>
</xs:element>
<xs:element name="Ord" type="xs:unsign edByte" />
<xs:element name="Hide" type="xs:boolea n" />
</xs:sequence>
</xs:complexType>
</xs:element>
<xs:element name="lst002Vie wList">
<xs:complexType >
<xs:sequence>
<xs:element name="pkViewLis tId" msdata:ReadOnly ="true"
msdata:AutoIncr ement="true" msdata:AutoIncr ementSeed="-1"
msdata:AutoIncr ementStep="-1" type="xs:int" />
<xs:element name="ViewName" >
<xs:simpleTyp e>
<xs:restricti on base="xs:string ">
<xs:maxLength value="25" />
</xs:restriction>
</xs:simpleType>
</xs:element>
<xs:element name="prefix">
<xs:simpleTyp e>
<xs:restricti on base="xs:string ">
<xs:maxLength value="4" />
</xs:restriction>
</xs:simpleType>
</xs:element>
<xs:element name="Ord" type="xs:unsign edByte" />
<xs:element name="Hide" type="xs:boolea n" />
</xs:sequence>
</xs:complexType>
</xs:element>
<xs:element name="lkp101Por tSize">
<xs:complexType >
<xs:sequence>
<xs:element name="pkPortSiz eId" msdata:ReadOnly ="true"
msdata:AutoIncr ement="true" msdata:AutoIncr ementSeed="-1"
msdata:AutoIncr ementStep="-1" type="xs:short" />
<xs:element name="PortSize" >
<xs:simpleTyp e>
<xs:restricti on base="xs:string ">
<xs:maxLength value="50" />
</xs:restriction>
</xs:simpleType>
</xs:element>
<xs:element name="Ord" type="xs:unsign edByte" />
<xs:element name="Hide" type="xs:boolea n" />
</xs:sequence>
</xs:complexType>
</xs:element>
<xs:element name="lkp102Pha se">
<xs:complexType >
<xs:sequence>
<xs:element name="pkPhaseId " msdata:ReadOnly ="true"
msdata:AutoIncr ement="true" msdata:AutoIncr ementSeed="-1"
msdata:AutoIncr ementStep="-1" type="xs:short" />
<xs:element name="Phase">
<xs:simpleTyp e>
<xs:restricti on base="xs:string ">
<xs:maxLength value="50" />
</xs:restriction>
</xs:simpleType>
</xs:element>
<xs:element name="Ord" type="xs:unsign edByte" />
<xs:element name="Hide" type="xs:boolea n" />
</xs:sequence>
</xs:complexType>
</xs:element>
<xs:element name="lkp103Sen sorConnection">
<xs:complexType >
<xs:sequence>
<xs:element name="pkSensorC onnectionId"
msdata:ReadOnly ="true" msdata:AutoIncr ement="true"
msdata:AutoIncr ementSeed="-1" msdata:AutoIncr ementStep="-1"
type="xs:short" />
<xs:element name="SensorCon nection">
<xs:simpleTyp e>
<xs:restricti on base="xs:string ">
<xs:maxLength value="50" />
</xs:restriction>
</xs:simpleType>
</xs:element>
<xs:element name="Ord" type="xs:unsign edByte" />
<xs:element name="Hide" type="xs:boolea n" />
</xs:sequence>
</xs:complexType>
</xs:element>
<xs:element name="lkp104Vol tage">
<xs:complexType >
<xs:sequence>
<xs:element name="pkVoltage Id" msdata:ReadOnly ="true"
msdata:AutoIncr ement="true" msdata:AutoIncr ementSeed="-1"
msdata:AutoIncr ementStep="-1" type="xs:short" />
<xs:element name="Voltage">
<xs:simpleTyp e>
<xs:restricti on base="xs:string ">
<xs:maxLength value="3" />
</xs:restriction>
</xs:simpleType>
</xs:element>
<xs:element name="Ord" type="xs:unsign edByte" />
<xs:element name="Hide" type="xs:boolea n" />
</xs:sequence>
</xs:complexType>
</xs:element>
<xs:element name="lkp105Pan elLocation">
<xs:complexType >
<xs:sequence>
<xs:element name="pkPanelLo cationId"
msdata:ReadOnly ="true" msdata:AutoIncr ement="true"
msdata:AutoIncr ementSeed="-1" msdata:AutoIncr ementStep="-1"
type="xs:short" />
<xs:element name="PanelLoca tion">
<xs:simpleTyp e>
<xs:restricti on base="xs:string ">
<xs:maxLength value="50" />
</xs:restriction>
</xs:simpleType>
</xs:element>
<xs:element name="Ord" type="xs:unsign edByte" />
<xs:element name="Hide" type="xs:boolea n" />
</xs:sequence>
</xs:complexType>
</xs:element>
<xs:element name="lkp201Dev iceType">
<xs:complexType >
<xs:sequence>
<xs:element name="pkDeviceT ypeId" msdata:ReadOnly ="true"
msdata:AutoIncr ement="true" msdata:AutoIncr ementSeed="-1"
msdata:AutoIncr ementStep="-1" type="xs:int" />
<xs:element name="DeviceNam e">
<xs:simpleTyp e>
<xs:restricti on base="xs:string ">
<xs:maxLength value="50" />
</xs:restriction>
</xs:simpleType>
</xs:element>
<xs:element name="Prefix">
<xs:simpleTyp e>
<xs:restricti on base="xs:string ">
<xs:maxLength value="4" />
</xs:restriction>
</xs:simpleType>
</xs:element>
<xs:element name="Valve" type="xs:boolea n" />
<xs:element name="Cylinder" type="xs:boolea n" />
<xs:element name="Sensors" type="xs:boolea n" />
<xs:element name="AirServ" type="xs:boolea n" />
<xs:element name="ElecServ" type="xs:boolea n" />
<xs:element name="HMI" type="xs:boolea n" />
<xs:element name="Note">
<xs:simpleTyp e>
<xs:restricti on base="xs:string ">
<xs:maxLength value="50" />
</xs:restriction>
</xs:simpleType>
</xs:element>
<xs:element name="Ord" type="xs:unsign edByte" />
<xs:element name="Hide" type="xs:boolea n" />
</xs:sequence>
</xs:complexType>
</xs:element>
<xs:element name="lkp202Com ponentType">
<xs:complexType >
<xs:sequence>
<xs:element name="pkCompone ntTypeId"
msdata:ReadOnly ="true" msdata:AutoIncr ement="true"
msdata:AutoIncr ementSeed="-1" msdata:AutoIncr ementStep="-1"
type="xs:int" />
<xs:element name="Component Name">
<xs:simpleTyp e>
<xs:restricti on base="xs:string ">
<xs:maxLength value="50" />
</xs:restriction>
</xs:simpleType>
</xs:element>
<xs:element name="Prefix">
<xs:simpleTyp e>
<xs:restricti on base="xs:string ">
<xs:maxLength value="4" />
</xs:restriction>
</xs:simpleType>
</xs:element>
<xs:element name="Ord" type="xs:unsign edByte" />
<xs:element name="Hide" type="xs:boolea n" />
</xs:sequence>
</xs:complexType>
</xs:element>
<xs:element name="lkp301Val veType">
<xs:complexType >
<xs:sequence>
<xs:element name="pkValveTy peId" msdata:ReadOnly ="true"
msdata:AutoIncr ement="true" msdata:AutoIncr ementSeed="-1"
msdata:AutoIncr ementStep="-1" type="xs:short" />
<xs:element name="ValveType ">
<xs:simpleTyp e>
<xs:restricti on base="xs:string ">
<xs:maxLength value="50" />
</xs:restriction>
</xs:simpleType>
</xs:element>
<xs:element name="Ord" type="xs:unsign edByte" />
<xs:element name="Hide" type="xs:boolea n" />
</xs:sequence>
</xs:complexType>
</xs:element>
<xs:element name="lkp302Sen sorType">
<xs:complexType >
<xs:sequence>
<xs:element name="pkSensorT ypeId" msdata:ReadOnly ="true"
msdata:AutoIncr ement="true" msdata:AutoIncr ementSeed="-1"
msdata:AutoIncr ementStep="-1" type="xs:short" />
<xs:element name="SensorTyp e">
<xs:simpleTyp e>
<xs:restricti on base="xs:string ">
<xs:maxLength value="50" />
</xs:restriction>
</xs:simpleType>
</xs:element>
<xs:element name="Ord" type="xs:unsign edByte" />
<xs:element name="Hide" type="xs:boolea n" />
</xs:sequence>
</xs:complexType>
</xs:element>
<xs:element name="lkp303Hmi Type">
<xs:complexType >
<xs:sequence>
<xs:element name="pkHmiType Id" msdata:ReadOnly ="true"
msdata:AutoIncr ement="true" msdata:AutoIncr ementSeed="-1"
msdata:AutoIncr ementStep="-1" type="xs:short" />
<xs:element name="HmiType">
<xs:simpleTyp e>
<xs:restricti on base="xs:string ">
<xs:maxLength value="50" />
</xs:restriction>
</xs:simpleType>
</xs:element>
<xs:element name="ION">
<xs:simpleTyp e>
<xs:restricti on base="xs:string ">
<xs:maxLength value="3" />
</xs:restriction>
</xs:simpleType>
</xs:element>
<xs:element name="Ord" type="xs:unsign edByte" />
<xs:element name="Hide" type="xs:boolea n" />
</xs:sequence>
</xs:complexType>
</xs:element>
</xs:choice>
</xs:complexType>
<xs:unique name="Constrain t1" msdata:PrimaryK ey="true">
<xs:selector xpath=".//tbl010Job" />
<xs:field xpath="pkJobId" />
</xs:unique>
<xs:unique name="tbl020Pro c_Constraint1"
msdata:Constrai ntName="Constra int1" msdata:PrimaryK ey="true">
<xs:selector xpath=".//tbl020Proc" />
<xs:field xpath="pkProces sId" />
</xs:unique>
<xs:unique name="tbl030Dev i_Constraint1"
msdata:Constrai ntName="Constra int1" msdata:PrimaryK ey="true">
<xs:selector xpath=".//tbl030Devi" />
<xs:field xpath="pkDevice Id" />
</xs:unique>
<xs:unique name="tbl040Cmp t_Constraint1"
msdata:Constrai ntName="Constra int1" msdata:PrimaryK ey="true">
<xs:selector xpath=".//tbl040Cmpt" />
<xs:field xpath="pkCompon entId" />
</xs:unique>
<xs:unique name="tbl050Ope r_Constraint1"
msdata:Constrai ntName="Constra int1" msdata:PrimaryK ey="true">
<xs:selector xpath=".//tbl050Oper" />
<xs:field xpath="pkOperId " />
</xs:unique>
<xs:unique name="tblUnion1 _Constraint1"
msdata:Constrai ntName="Constra int1" msdata:PrimaryK ey="true">
<xs:selector xpath=".//tblUnion1" />
<xs:field xpath="pkID_u1" />
</xs:unique>
<xs:unique name="lst00Mast erList_Constrai nt1"
msdata:Constrai ntName="Constra int1" msdata:PrimaryK ey="true">
<xs:selector xpath=".//lst00MasterList " />
<xs:field xpath="pkMaster ListId" />
</xs:unique>
<xs:unique name="lst002Vie wList_Constrain t1"
msdata:Constrai ntName="Constra int1" msdata:PrimaryK ey="true">
<xs:selector xpath=".//lst002ViewList" />
<xs:field xpath="pkViewLi stId" />
</xs:unique>
<xs:unique name="lkp101Por tSize_Constrain t1"
msdata:Constrai ntName="Constra int1" msdata:PrimaryK ey="true">
<xs:selector xpath=".//lkp101PortSize" />
<xs:field xpath="pkPortSi zeId" />
</xs:unique>
<xs:unique name="lkp102Pha se_Constraint1"
msdata:Constrai ntName="Constra int1" msdata:PrimaryK ey="true">
<xs:selector xpath=".//lkp102Phase" />
<xs:field xpath="pkPhaseI d" />
</xs:unique>
<xs:unique name="lkp103Sen sorConnection_C onstraint1"
msdata:Constrai ntName="Constra int1" msdata:PrimaryK ey="true">
<xs:selector xpath=".//lkp103SensorCon nection" />
<xs:field xpath="pkSensor ConnectionId" />
</xs:unique>
<xs:unique name="lkp104Vol tage_Constraint 1"
msdata:Constrai ntName="Constra int1" msdata:PrimaryK ey="true">
<xs:selector xpath=".//lkp104Voltage" />
<xs:field xpath="pkVoltag eId" />
</xs:unique>
<xs:unique name="lkp105Pan elLocation_Cons traint1"
msdata:Constrai ntName="Constra int1" msdata:PrimaryK ey="true">
<xs:selector xpath=".//lkp105PanelLoca tion" />
<xs:field xpath="pkPanelL ocationId" />
</xs:unique>
<xs:unique name="lkp201Dev iceType_Constra int1"
msdata:Constrai ntName="Constra int1" msdata:PrimaryK ey="true">
<xs:selector xpath=".//lkp201DeviceTyp e" />
<xs:field xpath="pkDevice TypeId" />
</xs:unique>
<xs:unique name="lkp202Com ponentType_Cons traint1"
msdata:Constrai ntName="Constra int1" msdata:PrimaryK ey="true">
<xs:selector xpath=".//lkp202Component Type" />
<xs:field xpath="pkCompon entTypeId" />
</xs:unique>
<xs:unique name="lkp301Val veType_Constrai nt1"
msdata:Constrai ntName="Constra int1" msdata:PrimaryK ey="true">
<xs:selector xpath=".//lkp301ValveType " />
<xs:field xpath="pkValveT ypeId" />
</xs:unique>
<xs:unique name="lkp302Sen sorType_Constra int1"
msdata:Constrai ntName="Constra int1" msdata:PrimaryK ey="true">
<xs:selector xpath=".//lkp302SensorTyp e" />
<xs:field xpath="pkSensor TypeId" />
</xs:unique>
<xs:unique name="lkp303Hmi Type_Constraint 1"
msdata:Constrai ntName="Constra int1" msdata:PrimaryK ey="true">
<xs:selector xpath=".//lkp303HmiType" />
<xs:field xpath="pkHmiTyp eId" />
</xs:unique>
<xs:keyref name="Lkp_tbl04 0Cmpt_lkp103Sen sorConnection"
refer="lkp103Se nsorConnection_ Constraint1">
<xs:selector xpath=".//tbl040Cmpt" />
<xs:field xpath="cmSmalli nt08" />
</xs:keyref>
<xs:keyref name="Lkp_tbl04 0Cmpt_lkp303Hmi Type"
refer="lkp303Hm iType_Constrain t1">
<xs:selector xpath=".//tbl040Cmpt" />
<xs:field xpath="cmSmalli nt07" />
</xs:keyref>
<xs:keyref name="Lkp_tbl04 0Cmpt_lkp302Sen sorType"
refer="lkp302Se nsorType_Constr aint1">
<xs:selector xpath=".//tbl040Cmpt" />
<xs:field xpath="cmSmalli nt06" />
</xs:keyref>
<xs:keyref name="Lkp_tbl04 0Cmpt_lkp101Por tSize"
refer="lkp101Po rtSize_Constrai nt1">
<xs:selector xpath=".//tbl040Cmpt" />
<xs:field xpath="cmSmalli nt05" />
</xs:keyref>
<xs:keyref name="Lkp_tbl04 0Cmpt_lkp301Val veType"
refer="lkp301Va lveType_Constra int1">
<xs:selector xpath=".//tbl040Cmpt" />
<xs:field xpath="cmSmalli nt04" />
</xs:keyref>
<xs:keyref name="Lkp_tbl04 0Cmpt_lkp105Pan elLocation"
refer="lkp105Pa nelLocation_Con straint1">
<xs:selector xpath=".//tbl040Cmpt" />
<xs:field xpath="cmSmalli nt03" />
</xs:keyref>
<xs:keyref name="Lkp_tbl04 0Cmpt_lkp102Pha se"
refer="lkp102Ph ase_Constraint1 ">
<xs:selector xpath=".//tbl040Cmpt" />
<xs:field xpath="cmSmalli nt02" />
</xs:keyref>
<xs:keyref name="Lkp_tbl04 0Cmpt_lkp104Vol tage"
refer="lkp104Vo ltage_Constrain t1">
<xs:selector xpath=".//tbl040Cmpt" />
<xs:field xpath="cmSmalli nt01" />
</xs:keyref>
<xs:keyref name="FK_tbl020 Proc_lkp201Devi ceType"
refer="lkp201De viceType_Constr aint1">
<xs:selector xpath=".//tbl020Proc" />
<xs:field xpath="fkDevice Type" />
</xs:keyref>
<xs:keyref name="FK_tbl010 Job_lkp102Phase "
refer="lkp102Ph ase_Constraint1 ">
<xs:selector xpath=".//tbl010Job" />
<xs:field xpath="SystemPh ase" />
</xs:keyref>
<xs:keyref name="FK_tbl010 Job_lkp104Volta ge"
refer="lkp104Vo ltage_Constrain t1">
<xs:selector xpath=".//tbl010Job" />
<xs:field xpath="SystemVo ltage" />
</xs:keyref>
</xs:element>
</xs:schema>
//
Thank you,
dbuchanan