InfoPath Dev

I figured it out!

Thanks for the reply clay. I see what you mean. On load form,     retrieve ID from  first table, put it in the buffer field, then increment the value of the first table by one.    users then  fill out form to second table (main data source) submit.   the problem is , I dont have the web service ...

Hi  Matt what if i dont have sharepoint library. I only got access .mdb. Can you help me on that. Thanks

hi Clay. Thanks. But the first submit will move the record pointer to the next one. Am I Right? How do I refer the pointer back to the last one. What I am trying to do is to get a unique id  from a table and put it to my form and after the users fill out the form, the unique ID along with other fields will be saved in the same record ...

Hi clay.   Thanks for the respond. I would like to be able to display that unique ID on my form, before it is saved in my access database. The logic : Users activate the the form. On load :          Get the uniqe ID number from a database ...

Hi, What if I want to take ID field (autonumber) from database access? Anyone, please help....