how to automatically enter field value from same field in previous record?

when user clicks to insert new record, how can i automatically populate field on insert page with data from previous record?

users will be visiting insert page from a records_Results page where all records will have identical data (referenceNumber) is same field

thx in advance

use a recordset to look up the value, and populate a hidden form element from the recordset, use that hidden element in the insert.

thx for the reply, i am working on it at the moment and if if it is ok and if get stuck maybe i can come back to you

one quick question, related to my application but not specifically this post - when i use the File Manipulation Wizard to set image size(s), does this REDUCE the image dimensions and FILE SIZE, or does it simply display the larger (larger file size) image at the selected dimensions?

please ignore my last question, i worked it out at this end. yes it does reduce file size - EXCELLENT!

PLEASE HELP!!! my brain is getting fried with this... let me explain further what i am doing, I would be grateful for any guidance

i have a table of properties and I have a table of photos, each property can have any number of photos associated with it

in the admin section of the site, on the property insert page or the property update page, i want the user to have the facility to view, add, delete and change photos associated with the property. i have created a field in the photos table called propertyRef, this should contain the same data as the id field in the properties table

question one: is this the correct approach?

my strategy is to utilize the properties insert and update pages to include a function for the user to view, add, delete and change related photos in the photos table and automatically insert the properties id into the photos propertyRef field

question two: is this the correct strategy?

question three: how do i get started?

Please provide a Skype username or a US phone number and a good time to contact you when you will be in front of your computer and we will have an engineer contact you to resolve this issue over the phone.

We are available Monday - Friday from 9am - 4pm EST (except major U.S. holidays).

private message w phn # attached

ok timing for call was not good yesterday... but I am sitting here now, or any time later this morning if that works for ya?! phn # in private message