How to view parent and child records in Access 2013?

[Havitosh]

Hello,


I'll give a simple example to explain my question.
I have 2 record's in a table- food & cloth.
In another table i keep records that belong to one of the previous records- meat & fruits for food,
shirt, hat, pants for cloth.
in third table i keep sub records for table 2- cow, ham for meat, orange for fruits etc..
All the table are connected with proper one to many relationships.


Is it possible to display the records in such a way that when i choose one records i will see the parent record and all it child's?
If its possible, can i set the display in 3 separate list's box so when i pick one record all other's will be highlighted according to their relationships?

[June7]

Sounds like form/subform (or report/subreport) arrangement.

What you describe for the listboxes sounds like dependent (cascading) controls http://www.datapigtechnologies.com/f...combobox2.html.

[Havitosh]

Sounds like form/subform (or report/subreport) arrangement.

What you describe for the listboxes sounds like dependent (cascading) controls http://www.datapigtechnologies.com/f...combobox2.html.

Hi June7,
Does your example work the other way as well? can you select location and have the region displayed?

[June7]

I presume a location can be in only one region. If so, having a combobox for region dependent on location combobox doesn't makes sense.

[Havitosh]

It makes sense if you have a location name and you want to know what region it is in, possible?

[June7]

The region could be another column in the combobox RowSource. All columns can be viewed in the drop down list. A textbox could have expression that references the region column.

Or a combobox could concatenate the location and region fields so both values will display in the combobox. Either way, a combobox for region is not needed.