Re: One to many relationships in FORMS (ISQL)

Kate, I'm pretty sure that this isn't possible in ISQL - I think it's a feature of 4GL, but I know what you mean, it would be a nice=20 feature to have. :-) The closest you can get in ISQL is, as you say, the Master/Detail relationship - query the order number in the=20 master table, then hit D(etail), and the form will select all items relating to that number, displaying them one at a time. Then use N(ext) and P(revious) to move through them. Sorry I can't help any more than this, it's a limitation of the = software! Cheers, Richard. ----------------------------------------------------------------- =20 | _ =AF\\ | Richard Thomas | | \\ 0_ | r.thomas@csl.gov.uk | | \\ / | | | oo/ | "20 Regal and a four-pack, | | / \\ | I guess I'm set for the night" | | \\_/ | - "TV Tan" The Wildhearts | ----------------------------------------------------------------- > From ilist@rmy.emory.edu Thu Sep 21 12:48:11 1995 > From: kcj@netcom.com (Kate Juliff) > Subject: One to many relationships in FORMS (ISQL) > Date: Thu, 21 Sep 1995 02:27:03 GMT > To: informix-list@rmy.emory.edu > X-Informix-List-To: rt10hp@csl.gov.uk > X-Informix-List-Id: <news.17176> >=20 >=20 > Is there any way I can set up a form such that it shows, for every = order,=20 > a list of existing line items? e.g. > Order number XXXX > Item 1 > Item 2 > Item n >=20 > I've read the manual and the master table idea gives me a hint this is = =20 > do-able but i can't see how.=20 > Thanks, >=20 > Kate >=20 >=20