narriative log

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

Guest

I have a situation where I need to type several narriatives. What I am
needing to do is specify 30 fields to hold the narriatives but I want a pop
up form that will go to the next field if one is used. Example:

Field 29 Used so open Field 30

and is it possible to enter a time stamp and user to each field that is
modified???

Thanks Jen
 
I have numerous fields but what it is being used for is a Police Logging
System. I need to type radio traffic as it was given and be able to show the
time and user that entered the narriative. Each call could contain numerous
narriative entries.

Jen
 
Let me back track a little. I have a table called Daily Dispatch Log. Each
call received is entered on a row with numerous columns that contain vital
information. Officer enroute, arrival, transport, clear, wreckers, etc. Now
during a call for the row I have numerous radio traffic to document. I need
to create a log system to document time and user for each narriative entered.
If I enter them by row then I am not able to link them to the seq. no. (ID).
 
Ms said:
I have a situation where I need to type several narriatives. What I
am needing to do is specify 30 fields to hold the narriatives but I
want a pop up form that will go to the next field if one is used.
Example:

Field 29 Used so open Field 30

and is it possible to enter a time stamp and user to each field that
is modified???

Thanks Jen
Click to expand...

You should have multiple ROWS, not multiple FIELDS.
 
Ms said:
I have numerous fields but what it is being used for is a Police
Logging System. I need to type radio traffic as it was given and be
able to show the time and user that entered the narriative. Each
call could contain numerous narriative entries.
Click to expand...

And those multiple entries should each be a record (row) with a field for
the narrative and a field for the DateTime (among others possible).

Table structures that resembles Field1 Field2 Field3 where the data in the
fields is similar are nearly always incorrect.
 
Ms said:
Let me back track a little. I have a table called Daily Dispatch
Log. Each call received is entered on a row with numerous columns
that contain vital information. Officer enroute, arrival, transport,
clear, wreckers, etc. Now during a call for the row I have numerous
radio traffic to document. I need to create a log system to document
time and user for each narriative entered. If I enter them by row
then I am not able to link them to the seq. no. (ID).
Click to expand...

Then you should have a child table for the radio traffic records and have a
one to many relationship between your current table and the new one.

The basic rule is a table for each entity. A radio traffic record is an
entity thus it gets a separate table.
 
So I am guessing to create the table and use the same seq no multiple time in
the ID field in the child table?????
 
Ms said:
So I am guessing to create the table and use the same seq no multiple
time in the ID field in the child table?????
Click to expand...

It would have its own Primary Key either consisting of real data fields or
an AutoNumber and it would also have a foreign key that would store the same
value as the parent record.

EX:

DispatchRecord
Id
1
2
3

RadioRecords
DispatchID RadioID
1 1
1 2
1 3
2 1
2 2
3 1
 
Rick is proposing the proper solution (as usual). To look at this in a
different perspective, consider the northwind order entry.

A Dispatch record would be similar to the Order record. Each additional call
back (or whatever) would be like the order details. There is one record per
product in the order details just as you would have one record per call
related to the master dispatch record.

You can add as many "call" records as you would like related to the initial
Dispatch record. Each call record can contain fields for CallDate, CallTime,
who, Comments,...
 
Rick I totally understand where you are going with the structure of the
table. Now one additional question I have is can I create the table to
automatically insert the ID no from the original table into a column? (I
understand your comment on the Auto Number for the Radio Log)
 
Ms said:
Rick I totally understand where you are going with the structure of
the table. Now one additional question I have is can I create the
table to automatically insert the ID no from the original table into
a column? (I understand your comment on the Auto Number for the Radio
Log)
Click to expand...

If you use a form/subform then the subform control will automatically
populate the linking field for you as you add new records. This is
dependent on the MasterLink and ChildLink properties of the subform control.
 
Back
Top