Thanks so much, Mark! That did the trick!
Mark Fuqua wrote:
Anne,
You have to tweak your code a bit. You have to change the value of the
display column to models.models instead of models.modelId. Note the sytax
(from plum help):
Full Syntax
<cf_DisplayFilteredSelect
parentTable = "ParentTableName"
primaryKey = "ColumnName"
primaryKeyType = "DataType"
foreignKey = "ColumnName"
displayColumn = "ColumnName" CHANGE THIS VALUE TO MODELS
displayColumnType = "DataType" CHANGE THIS TO VARCHAR(50) NOTE-VALUE IN()
SHOULD = WHAT IS SET IN ACCESS
required = "No | Yes"
label = "EntityName"
maximumNumberOfOptions = "30"
whereClauseExtension = "Plumuser.UserID=#GetAuthUser()#"
default = "ValueToInitiallyChooseOnAddForm"
orderByClause = "columnname ASC, columnname DESC">
You'll need to do this in code view. Also, you will need to change the
value of the maximumNumberOfOptions to be greater than the total number of
records in the database if you want the filtered select to display without
the "short text field" that is used to filter the filtered select. Here is
how it is explained in the PLUM help file:
DisplayFilteredSelect automatically switches between two modes:
fully
populated and filtered; which mode is chosen depends on the value of
maximumNumberOfOptions and the number of records retrieved from the parent
table.
If the total number of existing instances of the parent entity
(or in the
physical realm, the total number of rows in the parent table) is
less than
the value of maximumNumberOfOptions, the select menu will fully populate
with all existing instances of the parent entity:
If the value of maximumNumberOfOptions is less than the total
number of
rows in the parent table, the select menu will initially display
empty,
and a short text field will appear to its left. When the user types a
character or two in this "filter" field and presses Tab, the select
menu
populates with all parent entities that begin with the string
typed by the
user. Now the user can select from this menu the instance of the parent
entity to which he wants to relate the current instance of the
child
entity:
The help file for PLUM has a good explanation of this with pictures. From
the help menu, select PLUM help, then choose the contents tab: Choose Plum
framework, then expand "plum custom tags" then expand "form controls" then
select DisplayFilteredSelect.
Mark
-----Original Message-----
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] Behalf Of Anne
Girardeau
Sent: Sunday, October 30, 2005 11:55 AM
To: [email protected]
Subject: [plum] Auto Generated Forms
Ok, I have two Access DB tables, one called Makes and the other called
Models. Their structure is as follows:
Makes
MakeID autonumber
Make text
Models
ModelID autonumber
MakeID number
Model text
When I have Plum create the form that allows for the entry of new
models, it creates a form with a blank text box and a filtered list for
the MakeID DB Field which is a bit strange. How can I get rid of the
extra blank text box? Also, the MakeID filtered list doesn't show any
of the Make records when adding a new model. If you're editing a model,
the list will then only show the make that was originally assigned to
the model being edited. I'm attaching two screenshots to this message
so you can see exactly what I'm talking about. I'm assuming to fix both
of these issues I just need to tweak a database query some where but I'm
not sure. So any help with this would be greatly appreciated.
Thanks so much,
--Anne
**********************************************************************
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
**********************************************************************
