I created a table with a few queries. Now I need to add to the table. I
need to add columns for Children (sex and ages) and pets (what kind). Is
there any way of creating a sub-column to keep the data for each individual
new column together?
Thanks
STOP!!!
It sounds like you're working directly in table or query datasheets. These are
*very* limited.
It also sounds like you're trying to grow the table wider, with new fields for
Child1, Child2, Child3... Pet1, Pet2, Pet3... This is incorrect. Tables grow
vertically with new records, not horizontally. You would want a *new table*
for Children, related one-to-many to your current table; each new child would
be a new record in this table.
To interact with the data you would use a Form, probably with a couple of
Subforms (a subform for children and one for pets, for example).
See the tutorials at
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
for examples of how to design databases.
