Query or table wit subtable

[JC Huyser]

I have two tables with (1 items) and (2 transactions) on
items in "1". (eg. I have equipment in table"1".
Maintainance on equipment in Table "2"). this two tables
has common ID fields which I reference . I want to make
the table "2" a subtable of "1" but if I expand the + it
must give me only the transctions of that spesific item.

- 4312 | Church st robot |
4312 | clean gears |

+ 4311 | Masom Substation |

- 4310 | Pres St substation |
4310 | Sweep out dust |
4310 | repair roof |

 

[John Vinson]

I want to make
the table "2" a subtable of "1" but if I expand the + it
must give me only the transctions of that spesific item.

If you define a one-to-many relationship between the two tables using
the part number, this is exactly what you should get.

However, table datasheets (even with subtables) have *VERY* limited
utility. You may want to consider making a Form based on Table1, with
a Subform based on Table2, using the item number as the master/link
field. This will let you view and edit the transactions for each item
in association with the data for that item.

John W. Vinson[MVP]
(no longer chatting for now)