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)?



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.



Thanks for your help!