>Hi.
>I need a little help:
>I have two tables which are related through a
>variable "contrno." In table1 the contrno is
>unique to all elements. In Table2 it can be
>repeated for multiple fields. I wanted my
>application to have a screen which displays the
>contrno from Table1 and all the items in table2
>with contrno equal to it.
>I was able to accomplish this with a browse window
>of table2, but was wondering if I could do this
>some other way.
>
>anyone have any ideas?
>
>TIA,

Jason:

This is usually handled with a list-box. Use SQL to make an array containing the records required. If there is more than one field to display, use a proportional font, and concatenate the fields in the SQL. (cLName+cFname, etc.)

If you need multiple fields, you can provide a second screen displaying the fields from the record in the list-box.

If you need a BROWSE, try inBrowse - a terrific GenScrnX driver that nails a browse to your window, eliminating the unusual characteristics of the BROWSE window. You can download it from Compuserve if it isn't on the Yellow Pages.
Christophe BIEHLMANN
Compuserve: 100010,3412
71, rue Sevin Vincent
92210 Saint Cloud
FRANCE
FAX: (33) 1-46-02-53-63


If you want quick and powerful, get a RAD tool called FoxExpress. This is advertised in Fox magazines, and is a great help in learning these things and making really fast apps.

Hope this helps,
Randy