Data Entry
in [Tables]
|
From: sneeze on 5 Feb 2010 22:32 I have a Table called SNEEZE. It contains 6 fields eg A (date),B(name),C(invoice),D(details),E(units),F(price). Fields A,B,C are static and D E and F change. There are 5 transactions but A B and C remain but D E and F change. I would like to create a table or form that allows me to input A B and C but I can enter data for the other 5 transactions. End result should be 5 records in Table SNEEZE
From: Gina Whipp on 5 Feb 2010 22:49 sneeze, Sounds more like a one to many scenario, so you would need two tables... One for fields A, B and C and the the second talbe for the balance of the fields. Perhaps if you explain a wee bit more of what you are trying to accomplish we could help you better set up your tables. I'm also going to suggest you read the below for a better understanding of relational database design... Jeff Conrad's resources page... http://www.accessmvp.com/JConrad/accessjunkie/resources.html The Access Web resources page... http://www.mvps.org/access/resources/index.html A free tutorial written by Crystal (MS Access MVP)... http://allenbrowne.com/casu-22.html MVP Allen Browne's tutorials... http://allenbrowne.com/links.html#Tutorials Sample data models... http://www.databasedev.co.uk/table-of-contents.html -- Gina Whipp 2010 Microsoft MVP (Access) "I feel I have been denied critical, need to know, information!" - Tremors II http://www.regina-whipp.com/index_files/TipList.htm "sneeze" <sneeze(a)discussions.microsoft.com> wrote in message news:07D67862-2AF3-45F3-A672-E9B34E86F3D6(a)microsoft.com... I have a Table called SNEEZE. It contains 6 fields eg A (date),B(name),C(invoice),D(details),E(units),F(price). Fields A,B,C are static and D E and F change. There are 5 transactions but A B and C remain but D E and F change. I would like to create a table or form that allows me to input A B and C but I can enter data for the other 5 transactions. End result should be 5 records in Table SNEEZE
|
Pages: 1 Prev: Unbound Data Entry Form Next: Excel Embedded Object not Updating |