Database Results query

  • Thread starter Thread starter Ray
  • Start date Start date
R

Ray

I apologise for already posting this in the programming
group, but I didn't get any answers so I thought I'd try
here.
--------------------------------------------------------
I hope that whoever reads this can understand what I'm
trying to ask. I'm using the Database Results wizard, but
am adapting it for my own particular application. In the
following page
http://www.cclweb.co.uk/hccdb/books/tblMember/editor/datab
ase_editor_member.asp I would like to click on the
Identifier field and be able to see that Identifier
passed to appear pre-filled in the Submission Form.
In other words, if I click on the Identifier field on the
2nd row of data, I would like to see a "2" appear in the
Submission form's fkMember field. At present it remains
blank.
What I'm trying to do is, for a selected member, add a
number of Items that are owned by him, so I'll need his
Identifier to appear in the fkMember field of the Item
table.
 
In the
http://www.cclweb.co.uk/hccdb/books/tblMember/editor/new_it
em.asp page:

1. Right-click the fkMember text box.
2. Choose Form Field Properties.
3. Set the Initial Value text box to
<%=request("fkMember")%>

Jim Buyens
Microsoft FrontPage MVP
http://www.interlacken.com
Author of:
*----------------------------------------------------
|\---------------------------------------------------
|| Microsoft Office FrontPage 2003 Inside Out
||---------------------------------------------------
|| Web Database Development Step by Step .NET Edition
|| Microsoft FrontPage Version 2002 Inside Out
|| Faster Smarter Beginning Programming
|| (All from Microsoft Press)
|/---------------------------------------------------
*----------------------------------------------------
 
Jim
Thanks for your trouble - it worked. It's so simple when
you know how. I have bought your Inside Out book by the
way, very helpful.
Thanks again
Ray
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

SQL in FP2003 2
FP2003 with database problem 7
Unidentified Device on Network 4
ASP vs ASP.Net & database 2
Database 1
Database results format field 2
Session Variables (again!) 12
Database won't update 2

Back
Top