Table: dbo_Lookups

Primary Key: Id

Fields

Field	Type	Size	Required	PK
Id	Long	4	✓	✓
ShortNme	Text	255
Nme	Text	255
Descr	Text	255
Grp	Long	4
Active	Integer	2
Def	Integer	2
Sorting	Long	4
ValLnk1	Long	4
ValLnk2	Long	4
ValLnk3	Long	4
ValLnk4	Long	4
ValLnk5	Long	4
ValLnk6	Long	4
ValLnk7	Long	4
ValLnk8	Long	4
ValLnk9	Long	4
ValDte1	DateTime	8
ValDte2	DateTime	8
ValDte3	DateTime	8
ValBln1	Integer	2
ValBln2	Integer	2
ValBln3	Integer	2
ValBln4	Integer	2
ValBln5	Integer	2
ValCurr1	Currency	8
ValCurr2	Currency	8
ValCurr3	Currency	8
ValTxt1	Text	255
ValTxt2	Text	255
ValTxt3	Text	255
ValTxt4	Text	255
ValTxt5	Text	255
ValTxt6	Text	255
ValTxt7	Text	255
ValTxt8	Text	255
ValTxt9	Text	255
ValMem1	Memo	-
Blob	OLE	-
ValBln6	Integer	2
ValBln7	Integer	2
ValBln8	Integer	2
ValBln9	Integer	2
ValBln10	Integer	2
ValCurr4	Currency	8
ValCurr5	Currency	8
ValCurr6	Currency	8
ValCurr7	Currency	8
ValCurr8	Currency	8
ValCurr9	Currency	8