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. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
Automatically generate a new record in a second table?
|
Thread Tools | |
Display Modes | |
|
|
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 |