Paul Shearing
|
| Posted: 11/14/2005, 7:39 AM |
|
(CCS 3 latest Beta.)
I have created part of a website using the standard CCS wizard and this gives me the Search --> List --> Details structure. Great. FYI, this database contains a list of ships at sea.
On the details page, having searched and drilled-down to the record for a single ship, I need to display in addition to the detail fields, and on the same page, what in MS Access would be a simple subform, showing a list of related records (builder companies that were involved with the construction of this vessel).
What is the best way of going about this and how would I link this "subform" to the details record? The ship record is uniquely identified by an integer ID field: Vessel_ID and the subform (builders') records contain a corresponding integer field named VesselID.
I see quite a few postings that are to do with master/detail queries - perhaps there should be a generic Wizard for creating these structures if the process is a non-trivial or tricky one.
All the above is display-only so I do not have to worry about record updates.
Kind regards
Paul Shearing
Leafy Surrey in England
|
|
|
 |
peterr
Posts: 5971
|
| Posted: 11/14/2005, 10:32 AM |
|
Hi Paul,
First let me explain the concept of subforms:
Actually there is no concept of "subform" in CCS, while all Web forms are equivalent to "subforms". MS Access applications use subforms because the whole screen is basically a form. You cannot create multiple forms on one screen in MS Access, therefore you'd have to create a separate screen/form and add it to another screen as subform. In Web applications you can have multiple forms on a single screen/page, therefore every form is automatically a subform in a way.
Master/detail is also not needed here, as far as I can see.
You'd just need to add an additional form to your page, which is equivalent to adding a subform in MS Access.
Thus simply create a new form on your page and configure the Data Source to use Vessel_ID parameter, same as all other forms on that same page. That's it.
_________________
Peter R.
YesSoftware Forums Moderator
For product support please visit http://support.yessoftware.com |
 |
|
peterr
Posts: 5971
|
| Posted: 11/14/2005, 10:36 AM |
|
BTW, by creating an additional form, I meant that you need to add an additional Grid to your page, with the fields that you want to display.
_________________
Peter R.
YesSoftware Forums Moderator
For product support please visit http://support.yessoftware.com |
|
|
|
|
