Nate's tag worked pretty well for me, Tim. I was short of time and had to nest 3 groups of them on one form, so it was
much quicker than figuring out how to do this from qForms within the context of Plum.
If you are interested, let me know and I will send you a sample of what I did.
Jeff
Tim Blankenship wrote:
I need 2 selects.
1. pulls query and fills manufacturer
2. pulls query and fills model where man_id = Man_id
I will add a section in the admin portion to add new manufacturers and
models but plum can handle this fine with the single dropdown and text
input field.
I have Nates tag but I wasnt sure if one of Plums custom tags did this.
I have never used qForms, I'll take a look at it.
On Tue, 08 Feb 2005 11:23:00 -0500, Jeff Fleitz <[EMAIL PROTECTED]> wrote:
Hi Tim,
It seems to me that you would want to normalize your database, so I would go
with separate tables. Using Plum shouldn't
influence db design issues, IMO.
On the question of the forms, are you planning on putting 2 select menus on one
form, or on two separate forms
(ManufacturerAddForm, ModelAddform) for instance?
cf_FilteredSelect doesn't support chaining like that at this time, although I
asked for it. Maybe Adam and David will
consider it for v 1.1. If you are going for the former option, you will have to
do something like use Nate Weiss'
CF_TwoSelectsRelated tag, bracketed between a <cf_DisplayExtraFormContent> tag
pair. I did this on a project last year,
and had to use custom queries to drive it. qForms supports populating
multiple selects, also, so that is another
option. But no native way in Plum to popluate one select dymanically from
another at this point.
HTH,
Jeff
Tim Blankenship wrote:
Alright I know I should be ashamed, well I am, I need a little help.
What I want to do is have a form that lists some info on server
hardware that has a filtered select list on it.Basically I want to
choose a manufacturer (HP, IBM, Dell...) and when I choose the
manufacturer the Models are populated for the specific Manufacturer.
Example I choose HP in a select menu the next select menu is populated
with Proliant 123, Proliant 234, Proliant 345. So inturn what is the
best method for the DB design, a single table like
ID, man_ID, manufacturer, mod_id, model
or should I split them
Manufacturer table
man_id, manufacturer
Model table
mod_id, model, man_id
I know this is somewhat simple but I am just having a brainfart this morning.
For testing and client approval I am making it in Access but
eventually I will recreate this in Oracle.
**********************************************************************
You can subscribe to and unsubscribe from lists, and you can change
your subscriptions between normal and digest modes here:
http://www.productivityenhancement.com/support/DiscussionListsForm.cfm
**********************************************************************
**********************************************************************
You can subscribe to and unsubscribe from lists, and you can change
your subscriptions between normal and digest modes here:
http://www.productivityenhancement.com/support/DiscussionListsForm.cfm
**********************************************************************
