Ajoy Khaund wrote: > Hi All > I have an app in a pathologhy laboratory. In the reception the first data > entry takes place. > > Two tables Parent and Child. I am using views for both tables. > > Data is entered from one form to the Parent and Child. The Data shows as > saved successfully and even prints a chits with the data entered(done from > the view). > > Since there is a mad rush in the morning the form never shows any error but > the app in its fourth year now sometimes does not save the data generally in > the child table. By the time they realize it a lot of data entry has taken > place. > > Now what I need is: > > 1. How can I warn them at the earliest that data has not been entered into > the main Child table or Parent Table. > 2. What sort of solution can I give them. > > TIA > > Bobby >
Make sure you use primary keys. When you create the new parent record, make sure you get the newly created PK, and then make sure that PK is stored in the child tables as a foreign key (FK). Is TABLEUPDATE() returning .T. and are you using the lForce parameter set to .T. ? -- Michael J. Babcock, MCP MB Software Solutions, LLC http://mbsoftwaresolutions.com http://fabmate.com "Work smarter, not harder, with MBSS custom software solutions!" _______________________________________________ Post Messages to: [email protected] 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/[EMAIL PROTECTED] ** 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.
