Sorry, I thought you wanted to add a record(entry). Mark is right, just add a custom query and reference that using the
query attribute of the DisplayList tag.
Jeff
Tim Blankenship wrote:
Not sure if we are on the same page Jeff.
I have a list like follows
SN NAME
123 pooter
I want to add another field like TYPE
SN NAME TYPE
123 pooter server
SN and NAME are from table1
TYPE is from table2
They are not related(parent/child) but table1 and table2 have the
primary key of SN
On 8/24/05, *Jeff Fleitz* <[EMAIL PROTECTED]
<mailto:[EMAIL PROTECTED]>> wrote:
Hi Tim,
If I understand you correctly, try using something like the
following using a closing cf_DisplayListLinks tag, same as
what you would do for a normal drill-up/down (watch the line
wrap). Make sure that the AddFormAction page returns you
to this list using the redirect attribute in the cf_InsertRecord tag.
[<a
href="#Application.absoluteUrlRoot#/module/ModuleAddForm.cfm?PKID=#URLEncodedFormat(Trim(Attributes.listQuery.PKID[currentRow]))#&FromDrill=1">Add
Form</a>]
</cf_DisplayListLinks>
Jeff
Tim Blankenship wrote:
> Hello all, I have a list that I need to add a entry that is populated
> from a non related table but does share a common PK. What is the
best
> approach for this? Thanks
>
> --
> Tim Blankenship
> [EMAIL PROTECTED] <mailto:[EMAIL PROTECTED]>
<mailto:[EMAIL PROTECTED] <mailto:[EMAIL PROTECTED]> >
**********************************************************************
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
**********************************************************************
--
Tim Blankenship
[EMAIL PROTECTED] <mailto:[EMAIL PROTECTED]>
**********************************************************************
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
**********************************************************************
