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
|
|||
|
|||
Duplicating Data in Tables
Please help...this is killing me!
Is there any way that I can enter certain information in one table (i.e. account #) and it create a blank record in another table with with the same account #. I have the account # as the primary key. Thanks, Kristen |
#2
|
|||
|
|||
Duplicating Data in Tables
Generally, I would advise against a "blank related Record in another Table"
and only create a Record when required, i.e. storing valid, non-duplicated data. If you create a blank Record and then the user stops doing data entry, you end up with meaningless Record which will probably compromise your database later. You may like to explain in details why you need a "blank" Record and someone may propose a solution for you. -- HTH Van T. Dinh MVP (Access) "Kristen" wrote in message ... Please help...this is killing me! Is there any way that I can enter certain information in one table (i.e. account #) and it create a blank record in another table with with the same account #. I have the account # as the primary key. Thanks, Kristen |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Appending data from one table to multiple relational tables | Stranger | Running & Setting Up Queries | 42 | August 18th, 2004 02:55 AM |
Newbie? Do I use Report or Query | John Egan | New Users | 11 | June 28th, 2004 08:31 PM |
Link Tables to Access data queries | Sid | Tables | 3 | June 1st, 2004 09:31 AM |
Two Tables need same Data Type | Allison | Database Design | 0 | May 18th, 2004 04:26 PM |