Nested tables?

M

MLT

I'd trying to do something like a table within a table. That is, I
have a list of items in a table. Then, within each item, there is an
history which is a list of past orders for that particular item. How
might I go about doing something like this?
 
J

John W. Vinson

I'd trying to do something like a table within a table. That is, I
have a list of items in a table. Then, within each item, there is an
history which is a list of past orders for that particular item. How
might I go about doing something like this?
Click to expand...

By using a Form (based on the first table) with a Subform (based on the child
table).

Table datasheets are not designed or appropriate for user interaction. Tables
are designed to *store* data, not to present it or edit it.

You might want to look at some of these resources to get a feeling for how
Access works with relational data:

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
 
Top