Re: relational data base

--- "Martin A. Marques" <martin@math.unl.edu.ar> > wrote: >hello. >I'm trying to build a data base, that has to relate a specific field id to >another table in the data base. >Something like this: > >tb1.name -> tb2 > >where tb1.name is a string equal to the tb2 data base name. how is this >relation done? How can I select a determine table, depending on the name >field of the tb1 table? Well, without knowing what it is you're trying to do, I'd say you could select name from tb1 into a cursor and then FOREACH cursor you could create a select_stmt = "select <whatever> from ",tb1.name carlos == Maintainer of the procrastinator's FAQ. Well, maybe tomorrow I will be. _____________________________________________________________ Want a new web-based email account ? ---> http://www.firstlinux.net