doug@ridley.coyote.trw.com (Doug Rudoff) (11/21/90)
I'm having coming up with a specification of an Informix form and I'm wondering if someone could give me some help. Here is the problem (simplified a bit). I have the strname table (street name) which has these columns: int index char(20) name char(3) type index is a unique identifier for each row in the table. I have the intersection table to define intersections of two streets: int index1 char(20) name1 char(3) type1 int index2 char(20) name2 char(3) type2 A group of index1, name1, and type1 must match a row in the street name file. The same is true for index2, name2, and type2. I want to build a form where intersections can be entered: Index1 Name1 Type1 [ ] [ ] [ ] Index2 Name2 Type2 [ ] [ ] [ ] Only street names and type from the street name table should be able to be entered into the intersection fields. The index is never entered by the user in this form (except for queries). I would like that when a name and type are entered the matching index from the street name file to filled in the intersection's index fields. I have tried many times to come up with a form specification for this, but since index1, name1, and type1 AND index2, name2, and type2 are dependent on a row from the street name table, I cannot create an Informix form to do what I want. Please let me know if what I want to do here is possible in Informix, and how to do it if it is possible. Many thanks. -- =-=-=-=-=-=-=-=-=-=-=-=-=--=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=- Doug Rudoff Mobile Data International Bothell, WA (206) 487-5937 rudoff@mdi.com, uunet!mdisea!rudoff =-=-=-=-=-=-=-=-=-=-=-=-=--=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-