Wortz, Charles
CWortz at tea.state.tx.us
Fri Mar 7 13:10:00 CST 2003
And now it is the third posting of it today. Don't be so quick to repost. Wait a few hours. Charles Wortz Software Development Division Texas Education Agency 1701 N. Congress Ave Austin, TX 78701-1494 512-463-9493 CWortz at tea.state.tx.us -----Original Message----- From: Francisco H Tapia [mailto:my.lists at verizon.net] Sent: Friday 2003 Mar 07 13:02 To: AccessD Subject: [AccessD] Fw: Inserting line items from unbound form (A2k ADP) This email hasn't come through so I'm posting it on behalf of David McAfee -Francisco http://rcm.netfirms.com ----- Original Message ----- From: "David McAfee" <DMcAfee at haascnc.com> To: <dba-sqlserver at databaseadvisors.com> Cc: <accessd at databaseadvisors.com> Sent: Friday, March 07, 2003 10:34 AM Subject: FW: Inserting line items from unbound form (A2k ADP) : I didn't see this come through yesterday, so I'm trying it again.... : : I have an unbound form in an A2K ADP, that contains a listbox which : shows a list of parts (Qty, PN, Description, Price...) which are being : ordered for a given order. : To the right of this list box are 3 buttons (Add, Edit & Delete), upon : pressing any of these, I open a pop up (modal) form in which the user : can add (or edit or delete, depending on which mode I've sent in : openargs) an item (line item). : : I originally did this in A97, using a bound 'parent" (order) form and an : unbound pop up/modal "line item" entry, which would use DAO to insert, : edit or delete records then requery the list box (on the parent form). : : I cannot figure out how to recreate this in the all unbound ADP. : : 1. The parent "order" hasn't been entered yet, so I have no PK value to : assign to the child (Line item) table's FK, as I did in the A97 mdb. : 2. Because of the ADP, I have no local temp table creation ability. : 3. If I create a SPROC that creates a temp table in SQL, the temp tables : session expires upon completion of the SPROC, so how could I call it : back when I insert the parent tables' values? : : MTIA : David :