Informix SQL multi-table form question

Path: emory!swrinde!zaphod.mps.ohio-state.edu!menudo.uh.edu!usenet From: jet@karazm.math.uh.edu (J Eric Townsend) Newsgroups: comp.databases Message-ID: <1991Jul7.234405.5992@menudo.uh.edu> Date: 7 Jul 91 23:44:05 GMT Sender: usenet@menudo.uh.edu (USENET News System) Organization: University of Houston -- Department of Mathematics Nntp-Posting-Host: karazm.math.uh.edu I'm evalutating Informix's SQL, SE and Wingz products. I need to know if (and how) to do the following: Have a form that allows the user to type in a couple of fields about a person (possilby stored in table "people"). If there is no data for that person in the "people" table, the user can go ahead and enter data for both the "people" table and some other table, say, "form_a". If that person exists in "people", or if there are multiple matches in people, the user is allowed to select the proper person, and fill out the rest of "form_a". What I'm trying to avoid is the re-entering of a moderate amount of data on a person each time an entry for "form_a" needs to be filled out. Potentially, there could be hundreds of "form_a" rows for a single person. Also, there could be "form_[a-z]", each based on a person that *must* exist in the "people" table. I've looked at table joins, but I'm not sure exactly how to do (or if it can be done) this sort of thing. email, thx, I'll summarize if anyone cares. (Code fragments would be *really* helpful.) -- J. Eric Townsend - jet@uh.edu - bitnet: jet@UHOU - vox: (713) 749-2126 Systems Wrangler, University of Houston Department of Mathematics Skate UNIX! (curb fault: skater dumped) PowerGlove mailing list: glove-list-request@karazm.math.uh.edu