Skip to main content
F
ferrarikid123
Participating Frequently
May 9, 2006
Question

Database question

  • May 9, 2006
  • 1 reply
  • 561 views
I've created an "insert record" using the wizard. How would I display this information from the database on another page, once a user enters information into the first page? I keep getting information on the second page from the first record. I need the second page to show the latest record, ie what was inserted into the first page. I'm sure its very simple, but I've spent hours reading books and its not a common tast to perform. A master detail page won't acheive this as it only displays information from "already created" records. Hope that make sense? Thanks very much
This topic has been closed for replies.

1 reply

A
Anonymous
May 9, 2006
If I understand you correctly, I think you need the SQL in your recordset for the second display page to include the orderoing of your unique recordID

ORDER BY DESC

This will allow you to order your recordID in descending order (last first). You will then just diplay one record on the page (the last one entered).

Hope this is what you are after.

Jules
F
ferrarikid123Author
Participating Frequently
May 9, 2006
hmmmm, that makes sense. Do you mean displaying all the ID's for the records on the second page and setting it so that only the last ID is displayed? How would you make only the last record display this? Because they are all records and not separate fields so the applying of "ascending" wouldn't work? Thanks Jules
A
Anonymous
May 9, 2006
You would need to remove any Repeat Region behaviour on your second page. Your page will only then pull the first record to display and because your SQL is ORDER BY DESC it will display the last record only.
Terms & ConditionsAccessibility statement
Using the community Terms of use Privacy Cookie preferences Do not sell or share my personal information ad choicesAdChoices