thnx dude will give this a bash and let u know very much appreciated

metawizard2

sorry my bad

the representation is correct the only problem that i for see is where the user has more than one user :

fkiuser - varuserid - varname...

Grasshopper the field we would use is the varuserid which will be te employee number and unique further if need be we can filter on varname and varsurname and also...

okay let me describe it the following way:

in my user table tbllmsuser i have the following fields:

3pkiUsernumeric90

0varUserIDnvarchar501

0varNamenvarchar1001

0varSurnamenvarchar1001

0nBUIDnumeric91

0varEmailnvarchar1001

0varTelnvarchar501

0varPasswordnvarchar501

0varTitlenvarchar1001

0nLMSGroupdecimal91

0tiUserActivetinyint11

0tiUserAdmintinyint11

0varFaxnvarchar501

0BUReportertinyint11

0nBUDepartmentIdnumeric91

0nBUDivisionIdnumeric91

0nSecurityProfilenumeric91

0bYesNoActivebit11

0dtExpDatedatetime81

0iCounterint41

0varSourcevarchar501

0fkiLineManagernumeric91

0dtLastLogindatetime81

0nLoginCountnumeric91

0dtCurrentLogindatetime81

0varCellNumbervarchar501

0varEmploymentStatusvarchar501

0varInitialsvarchar501

0npasswordnumeric91

0tiOnlinetinyint11

0fkiLocationnumeric91

0tiRegistertinyint11

0nPersonnelNumbervarchar501

0tiTemporarytinyint11

0dtTemporaryAccessExpirationdatetime81

this table is also linked to the userdetail table tbllmsuserdetail through pkiuser and fkiuser:

3pkiLMSUserDetailnumeric90

0fkiUsernumeric90

0varAddressTypevarchar501

0varAddress1varchar2551

0varAddress2varchar2551

0varAddress3varchar2551

0varCityvarchar2551

0varPostalCodevarchar501

0tiSAOthertinyint11

0varNationalityvarchar2551

0varIDNovarchar501

0varIDTypevarchar2551

0dtDateOfBirthdatetime81

0varCellNumbervarchar501

0varPreferredCommunicationvarchar201

0varIBTCostCentervarchar501

0varConsultantNumbervarchar501

0varRacevarchar501

0tiGendertinyint11

0tiDisabledtinyint11

0varPhysicalLocationvarchar10001

0varOrganisationalGroupingvarchar501

0fkiLMSOccupationalnumeric91

0varJFLgradevarchar2551

0tiPrimarySecondarytinyint11

0tiSuperUsertinyint10

0varEmploymentStatusvarchar501

0tiAssessorModeratortinyint11

0varInitialsvarchar101

0varHomeLanguagevarchar2551

0varCitizenResidenceStatusvarchar501

0tiInternalExternaltinyint10

0varProvincialRegionvarchar501

0tiRegisteredStatustinyint10

0fkiRegistrationvarchar2551

0dtDateRegistrationStatusdatetime81

0dtDateOfTrainingdatetime81

0varTrainedByvarchar2551

0tiDocumentationFiledtinyint10

0tiDocumentationSenttinyint10

0varRegistrationReasonvarchar2551

0varCountryvarchar501

0fkiVenuenumeric91

0fkiCountrynumeric51

and...