query display

  • Thread starter Thread starter mrs
  • Start date Start date
M

mrs

This may be a little long.

I have a tbl that holds discrepancy data. The tbl's
primary key is linked to another tbl description. This
gives several descriptions for each discrepancy. I'm
doing this so that each person that works on the
discrepancy gets their own description record.

When I view the discrepancy tbl I get a plus sign that
expands displaying all associated descriptions, which
format I like.

How can I query and make the display with the plus sign?

Currently I'm getting a record that contains all info in
the discrepancy tbl for each record in the description
tbl. This is a lot of duplicate info.
 
I'm also working to see if subforms can give me the
desired view. Does this seem correct?

Matt
 
Back
Top