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
|
|||
|
|||
Data Entry
I have a Table called SNEEZE. It contains 6 fields eg A
(date),B(name),C(invoice),D(details),E(units),F(pr ice). 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 |
#2
|
|||
|
|||
Data Entry
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/acc...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" wrote in message ... I have a Table called SNEEZE. It contains 6 fields eg A (date),B(name),C(invoice),D(details),E(units),F(pr ice). 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 |
Thread Tools | |
Display Modes | |
|
|