Data Entry

[sneeze]

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

 

[Gina Whipp]

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

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