I am creating my first ADP file in Access 2000/SQL Server 2000. I have a form with unbound controls that will be used to create records in several SQL Server tables. There is a one-to-many relationship between some of the fields on the main form and the fields I have on my subform.
So far, the fields on both the form and the subform are unbound, and both the form and the subform are unbound.
In order for the subform to show up as "continuous forms" and allow for many records to be created for each record created on the main form, I'm pretty sure I have to bind the subform to *something*. In an Access .mdb file, I would bind it to a local temp table, but there are no local tables in an .adp file.
If I create a temp table on SQL Server using a stored proc, how can I bind the subform to that temp table? Will each user have his own temp table (that's what I want)? Should I create the temp table (call a proc that creates it) on the Load event of my form? Won't the temp table disappear as soon as the proc finishes running? How do I keep the temp table open until I want to drop it (at the form's close event)?
Since this is a multi-part question, I'm awarding the maximum available points (300) to the first person who gives me a usable answer. I either need to know how to create, keep open, and bind to a temp server table, or I need an alternative way to have multiple records display on a subform in an Access 2000 .adp file.