Jim Lawrence (AccessD)
accessd at shaw.ca
Fri Mar 7 12:58:00 CST 2003
-----Original Message----- From: accessd-admin at databaseadvisors.com [mailto:accessd-admin at databaseadvisors.com]On Behalf Of David McAfee Sent: Friday, March 07, 2003 10:35 AM To: 'dba-sqlserver at databaseadvisors.com' Cc: 'accessd at databaseadvisors.com' 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 -------------- next part -------------- A non-text attachment was scrubbed... Name: winmail.dat Type: application/ms-tnef Size: 1032 bytes Desc: not available URL: <http://databaseadvisors.com/pipermail/accessd/attachments/20030307/ff431dc7/attachment-0001.bin>