John Colby
jwcolby at ColbyConsulting.com
Tue Feb 28 21:14:06 CST 2006
In fact this is the approach I am leaning towards. It is not as fast (data entry) as a single form but makes the division of labor much cleaner. John W. Colby www.ColbyConsulting.com -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Joe Hecht Sent: Tuesday, February 28, 2006 9:45 PM To: 'Access Developers discussion and problem solving' Subject: Re: [AccessD] Entering data in related tables in a single form John, I am doing this with forms and sub forms on a tab control? I can send it to you if you need. It is the project I have been nagging the list about. Joe Hecht jmhecht at earthlink.net -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of John Colby Sent: Tuesday, February 28, 2006 12:13 PM To: 'Access Developers discussion and problem solving' Subject: Re: [AccessD] Entering data in related tables in a single form These are papers in boxes. Beyond that I do not know. Since the total fields they intend to enter is about 20 or so, the client intends to just "key it in". John W. Colby www.ColbyConsulting.com -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Hale, Jim Sent: Tuesday, February 28, 2006 1:56 PM To: 'Access Developers discussion and problem solving' Subject: Re: [AccessD] Entering data in related tables in a single form Is the data on paper (and must be input by hand) or electronic forms (where maybe it could be parsed quickly with Monarch?) Jim Hale -----Original Message----- From: John Colby [mailto:jwcolby at colbyconsulting.com] Sent: Tuesday, February 28, 2006 12:41 PM To: 'Access Developers discussion and problem solving' Subject: Re: [AccessD] Entering data in related tables in a single form >I suppose your base is in "bounders camp" while looking for this >"quick and dirty form" solution :) LOL, yea, given I am an unholy bounder, going unbound would not qualify as quick and dirty. I have discovered that as long as you include the PK/FK pairs, and populate the data in the parent/child order it seems to work. This is a moderately complex database, normalized, with lookup tables etc. and I need to get about 3 or 4 of the major tables populated with new claim / claimant / policy data from a ton of new claims on an "emergency" basis (2000 claims input in then next couple of days). John W. Colby www.ColbyConsulting.com -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Shamil Salakhetdinov Sent: Tuesday, February 28, 2006 1:36 PM To: Access Developers discussion and problem solving Subject: Re: [AccessD] Entering data in related tables in a single form <<< > seem to remember trying this ages ago with less than stellar results. >>> John, What issues do you mean? (It should work well in MS Access with properly organized forms (with subforms) and maybe with a few lines of code)... I suppose your base is in "bounders camp" while looking for this "quick and dirty form" solution :) Shamil ----- Original Message ----- From: "John Colby" <jwcolby at ColbyConsulting.com> To: "'Access Developers discussion and problem solving'" <accessd at databaseadvisors.com> Sent: Tuesday, February 28, 2006 9:02 PM Subject: [AccessD] Entering data in related tables in a single form >I need a quick and dirty form to enter data into a whole set of related >data tables. Policy holder, policy, claim, claimant etc. > > Is this possible? Obviously I have relational integrity turned on so > the PKs have to exist in the "parent" tables before they can be used > to enter data into the child tables. I seem to remember trying this > ages ago with less than stellar results. Has anyone here done > something like this, and if so how? > > John W. Colby > www.ColbyConsulting.com > > > -- > AccessD mailing list > AccessD at databaseadvisors.com > http://databaseadvisors.com/mailman/listinfo/accessd > Website: http://www.databaseadvisors.com -- AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com -- AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com ************************************************************ *********** The information transmitted is intended solely for the individual or entity to which it is addressed and may contain confidential and/or privileged material. Any review, retransmission, dissemination or other use of or taking action in reliance upon this information by persons or entities other than the intended recipient is prohibited. If you have received this email in error please contact the sender and delete the material from any computer. As a recipient of this email, you are responsible for screening its contents and the contents of any attachments for the presence of viruses. No liability is accepted for any damages caused by any virus transmitted by this email. -- AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com -- AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com -- AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com