Best way to pull and display data

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I'm putting together a security log. One component is an activity log viewer
that sorts by date/incident type. I pull from 2 tables tblIncident and tbl
Incidentofficer with a one-many relationship based on Incident ID. I'm trying
to get each incident on one line in a continous form.

The problem is pulling in the officer IDs. I'm getting all of them just not
the ones connected to the incident. The simplest way is a subreport but it
barks with continous forms. How can I display a list of officers connected
with each incident?
lstbox /combobox?
 
Or...how do I structure the underlying query to bring back all the officerIDs
but only one activity record. (avoid multiple records listed)

Thanks
 
barks with continous forms.

HUH?

Not sure why subreport or subform won't work with IncidentID being the link
field?
 
aWhen I try to create a subreport it throws-up a messege that says subreports
cannot be used in continous forms and converts the form to a single view.
 
Constructing a query to include the officerID may be the best solution if
only one officer is associated with one incident. If there can be more that
one officer per incident, then in a continuous form, you would end up with
multiple rows per incident (one per officer).

You may need to rethink the construction of your forms.
Let me know what the incident/officer relationship is, and I can help with
some ideas.
 
Yes there can be more than one officer per incident and as you mentioned I do
get multiple rows per incident.


All ideas appreciated -thanks

Todd
 
Well, then we do have a problem. I will assume there is a reason using a
continuous form; however, as you have found, a continuous form cannot have a
subform. The problem is, you need a subform to avoid the multiple rows.

Usually, when developers are using a continuous form, it is to allow the
user to see as much information about the records as possible. One way to
resolve this issue is to exclude the officers from the continuous form as
well as any other data the user doesn't really need to make a decision on
which incident they want to view. Once the user has made a selection (maybe
with a command button). Use a new single record form for entering/Editing
incidents. Have a subform in this form for the officers.
 
What is there were 1000 officers associated with one incident, in other
words, what if there were many detail records associated with one master
record. How would you want the report to look since it would probably be too
wide for an 81/2 by 11 paper.

You can do this with a report easier than a form
 
Back
Top