A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Access » Using Forms
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Automatically generate a new record in a second table?



 
 
Thread Tools Display Modes
  #1  
Old November 7th, 2005, 11:05 PM
external usenet poster
 
Posts: n/a
Default Automatically generate a new record in a second table?

In my Access 2000.DB, Table_Main (primary key "Key" (auto-number))
contains details of transactions (date, category, amount, receipt
number. etc ). The table is accessed via Form_Main. For all but one
of the 20-odd categories the information stored in Table_Main is
sufficient.

For the remaining category, "Special" (which only occurs a couple
of times a year), another seven fields of information are required. It
would be misleading to have the additional fields visible in Form_Main
or stored in Table_Main, so they live in Table_Extra, keyed by
"Reference" (integer). Table_Main.Key and Table_Extra.Reference
are joined in a 1:1 relationship.

Could someone please suggest how I can get a new record to be opened
automatically in Table_Extra, with the correct value of
"Reference", whenever a new record with category = "Special" is
established in Form_Main and without intervention by the DB user? The
various categories, including "Special" are user selected from a
list box. I'm quite happy to have the user subsequently populate the
remaining fields of Table_Extra via another Form, Form_Extra..

With thanks

John

 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Add New Field to DB Karen Database Design 7 October 19th, 2005 08:03 PM
Help again from Ken Snell (Query) Randy Running & Setting Up Queries 22 August 29th, 2005 08:15 PM
Need Help In Printing Current Record in Specific Report RNUSZ@OKDPS Setting Up & Running Reports 1 May 16th, 2005 09:06 PM
Unable to edit records in a form or query Merlin Using Forms 7 May 10th, 2005 02:00 PM
Design help, please SillySally Using Forms 27 March 6th, 2005 05:11 AM


All times are GMT +1. The time now is 06:25 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.