Well, all my views are created on the fly using CREATEOBJECT(), amazing fast. Therefore when I set the default value for the parent view I make it call the "NewId()" function. The PK is created when a new record is inserted. When I Append Blank in the child views I already know the FKey.
As the MDI form is destroyed so are the views. For each instance the View has a different name(SYS(2015) in the database but the Alias is given by me and belongs to the DataSession defined. E. >________________________________ > From: Stephen Russell <srussell...@gmail.com> >To: ProFox Email List <profox@leafe.com> >Sent: Monday, July 16, 2012 5:25 PM >Subject: Re: another rookie question > >How to do capture the ID it created for use in FKey columns for >adjoining tables? Just stuffing data into a single table is easy. > > --- StripMime Report -- processed MIME parts --- multipart/alternative text/plain (text body -- kept) text/html --- _______________________________________________ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/1342477695.13421.yahoomail...@web160803.mail.bf1.yahoo.com ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
