Re: Help with Informix/SQL - Novice warning!

John Pritchard writes: -> ->We tested and would like to use option 2. What we did not accomplish is ->option 2 using two fields to identify the unique record. For example: -> ->The table in the application in which we are moving to looks kind of like... -> org char(16) -> account char(8) -> bud1 decimal(12,2) not null -> bud2 decimal(12,2) not null -> : -> : -> ->The table we build from the old data looks like... -> org char(16) -> account char(8) -> bud1 decimal(12,2) not null From a design perspective, it looks like you moving from a relational table to a non-relational table. Is there some reason you're doing this? Relational databases are generally easier to work with. Regards, - Cathy -------------------------------------------------------------------------------- Cathy Kipp e-mail: ckipp@vth1.vth.colostate.edu Phone: (303) 491-1294 Colorado State University Veterinary Teaching Hospital Fax: (303) 491-1205