Spread Sheet Like Form

From: Brian Neary <bneary_at_gnosis-is.com>
Date: Mon, 4 Oct 1999 14:04:16 -0700
Message-ID: <AP8K3.38$m22.280500_at_news.bctel.net>

Is there anyway to create a form that looks like a spreadsheet. I have two tables name tab_x (the parent)and tab_y (the child) and I want to display the data in the following format:

tab_x.item1 tab_y.item1 tab_y.item2, tab_y.item3

                       tab_y.item1   tab_y.item2, tab_y.item3
                       tab_y.item1   tab_y.item2, tab_y.item3
tab_x.item1   tab_y.item1   tab_y.item2, tab_y.item3
                       tab_y.item1   tab_y.item2, tab_y.item3
                       tab_y.item1   tab_y.item2, tab_y.item3
                       tab_y.item1   tab_y.item2, tab_y.item3
                       tab_y.item1   tab_y.item2, tab_y.item3
tab_x.item1   tab_y.item1   tab_y.item2, tab_y.item3
                       tab_y.item1   tab_y.item2, tab_y.item3

The number of child rows in tab_y will vary. The users want to see all the tab_x items on the form so they can just scroll down to the one they want. They also don't want the tab_x.item1 to repeat on every line. It should only be shown on the first line, just like a spreadsheet. Any help will be appreciated.
Thanks Brian Received on Mon Oct 04 1999 - 23:04:16 CEST