saving data to a 2nd database is it possible

[RebeccaBleney]

Hi guys

If you have been reading any of my postings you will relise I'm new to this and have no idea what I'm doing.  Again I'm asking for advice.  I want to achieve two different things

1)  I want a unique consecutive number, I know I can achieve this in Studio up to 100 very easily and suits two of my forms.  But I want to be able to go up to 600 in another form.

2) I also want one field to open up with the same data that was inputed the entry before, just to save time for the field operator.

To my simple way of looking at things is if I establish a database that sole purpose is to store the data I could easily use "additemfromtable" to retreive it.  But I don't know how to send the data to a second database.  The obvious code to me is "save" but it looks like that it is used for only maps.  I have read other suggestions but to me this could be used with little coding.  So I'm asking is this possible?

Rebecca

[RebeccaBleney]

For those of you who are interested.

I still can't save to a second database, but I've solved my problems by using a button to read the last entry in the recordset and filling one field with the same data and the other field with a consecutive number proably a lot better then I was orginally planning.  If you are wondering why I wanted to create my own consecutive numbering system because I wanted to start at different numbers beside one and I wanted to restart the count when I wanted to.
I still would like to know how to write to a second database.
I assume you have to do
recordset
open database
createnew
update

but I'm just not getting there,  anybody got any idea I would appreciate a hint it.

Rebecca