JPH09114572A - Record data input device - Google Patents

Abstract

PROBLEM TO BE SOLVED: To properly input each selection item data as item data by enabling plural desired item data to be selected at a time out of reference data which are listed in a subwindow, etc. SOLUTION: When plural item data are selected out of the reference data listed in the subwindow 22 by an item data referring function, the respective selected item data are inputted through document creation processing to specified input item positions of corresponding records in order on the basis of the record of an input item specified with the cursor 21 as a reference record so that the selected item data are put in the respective data-uninputted records in the selection order at specified item positions successively from the reference record.

Description

Detailed Description of the Invention

[0001]

BACKGROUND OF THE INVENTION 1. Field of the Invention The present invention relates to a record data input device, and more particularly, when a plurality of item data are set in advance for a designated input item, the plurality of item data are displayed in a sub window. The present invention relates to a record data input device having a function of referring to item data for displaying a list by, for example.

[0002]

2. Description of the Related Art In recent years, various application programs such as spreadsheets and databases have been used in office computers and general-purpose computers mainly for office work. Can be created and managed. Some of such various application programs have an item data reference function (or item data copying function) in order to reduce an operator's work load regarding data input when creating form data.

This item data reference function creates and stores frequently used item data and related information thereof in a predetermined file as reference data for a specific item in advance so that the form data can be created. When the input item designated by the operator is an item having reference data, it is a function of displaying a list of reference data composed of a plurality of item data stored in the predetermined file by a sub window or the like. Furthermore, with this item data reference function, desired item data can be selected from the reference data displayed in a list in a sub-window, and the selected item data can be input as the data of the input item designated by the operator. You can

By providing such item data reference function in various application programs for creating and managing form data in the related art, the work load on the operator for data input when creating form data is reduced.

[0005]

However, in such a conventional item data reference function, only one desired item data can be selected at a time from the reference data displayed in a list in the sub window or the like. Since only one item data can be input at a time, there are problems as described below.

That is, when creating form data, when there are a plurality of input items for which data can be input by specific reference data, the operator uses the cursor keys to select the input items one by one. It is necessary to select the desired item data one by one from the same reference data displayed in a list by the item data reference function and input the data.
There is a problem that the operation is complicated and the usability is poor.

The present invention has been made in view of the above contents, and it is possible to select a plurality of desired item data at a time from the reference data displayed in a list by a sub window or the like. It is an object of the present invention to provide a record data input device having an item data reference function that can be appropriately input as item data.

[0008]

According to the first aspect of the present invention,
In a record data input device for inputting record data composed of a plurality of item data, when a plurality of item data are set in advance for a designated input item when the record data is input, Setting item display means for displaying a list of item data of the item, selection control means for controlling so that a desired plurality of item data can be selected from the plurality of item data displayed by the setting item display means, and the selection When a plurality of item data is selected under the control of the control means, in the same number of selected items as the number of the selected input item positions in which no data has been input, the specified input item positions of the respective records are The above object is achieved by including item data input means for inputting each selection item data.

Therefore, according to the first aspect of the invention, when a plurality of desired item data is selected from the plurality of item data displayed by the setting item display means under the control of the selection control means. In addition, the item data inputting means can input the selection item data to the specified input item positions of the respective records in the same number of records as the number of the selection items and in which no data has been input to the specified input item positions. Become.

Therefore, in the item data reference function, it is possible to select and input a plurality of item data at a time, so that it is possible to reduce the operator's work load for data input when creating the form data.

In this case, as described in claim 2, the selection control means controls so that a desired plurality of item data can be selected from the plurality of item data displayed in a list by the setting item display means. In addition, the quantity of each desired item data is controlled so that it can be input, and the item data input means selects a plurality of item data under the control of the selection control means, and the selected item data. When the quantity of is input, the number of the selection item data is the same as the sum of the quantities of the selection item data, and the selection item data is set to the specified input item position of each record. It is effective to input in accordance with each quantity.

Therefore, according to the second aspect of the present invention, a plurality of desired item data are selected from the plurality of item data displayed by the setting item display unit under the control of the selection control unit. , When the quantity of each selected item data is input, the item data input means
In the same number as the total of the quantity of each selection item data, in the record in which the data has not been input in the designated input item position, input each selection item data in the designated input item position of each record according to each quantity. Is possible.

Therefore, in the item data reference function, the selected item data can be input into the form data being created for each quantity, so that the work load on the operator for data input can be reduced when creating the form data. You can

Further, in this case, as described in claim 3, when a plurality of item data is selected under the control of the selection control means, the designated input item positions of the same number as the selected item number are selected. When there is no record for which data has not been input, it is effective to provide a record generation means for generating the insufficient record.

According to the third aspect of the present invention, when a plurality of item data are selected under the control of the selection control means, the record generation means causes the designated input item positions of the same number as the number of the selected items. If there is no record for which data has not been input, it is possible to generate the insufficient record.

Therefore, since it is not necessary for the operator to instruct creation of the insufficient records, it is possible to reduce the work load on the operator for data input when creating the form data.

[0017]

BEST MODE FOR CARRYING OUT THE INVENTION Hereinafter, preferred embodiments of the present invention will be described in detail with reference to FIGS. 1 to 1
FIG. 4 is a diagram showing a first example of an embodiment of a computer system to which the record data input device of the present invention is applied.

First, the configuration will be described. FIG. 1 is a block diagram showing the overall configuration of a computer system 1 to which the present invention is applied. In FIG. 1, the computer system 1 includes an input unit 11, a ROM 12, and a record file 1.
3, a CPU 14, a display unit 15, a work memory 16, a form definition memory 17, and a table file 18. Further, the input unit 11 includes a key input unit 11a.
And a mouse 11b are provided.

The input unit 11 includes a key input unit 11a and a mouse 11b.
It has function keys, numerical keys, character keys, cursor keys, etc., and outputs various operation signals to the CPU 14 according to various key operations by the operator. In addition, mouse 1
Reference numeral 1b is a pointing device for selecting operation menus and icons displayed on the display screen of the display unit 15 at the time of form creation processing described later, and outputs relative position coordinate information to the CPU 14.

A ROM (Read Only Memory) 12 stores various control programs for controlling each section of the computer system 1 executed by the CPU 14, such as a form creation processing program described later. Record file 1
Reference numeral 3 forms a memory area for storing a plurality of form data created by a form creating process described later.

CPU (Central Processing Unit) 14
Controls each part of the computer system 1 according to various control programs stored in the ROM 12. Specifically, when the input unit 11 instructs the CPU 14 to shift to the reference table setting mode, the CPU 14 executes a reference table setting process described later, and based on the data input from the input unit 11, the work memory After creating a reference table in 16 and setting the environment of the item data reference function based on the reference table, the reference table is stored in the table file 18.

Further, when the CPU 14 is instructed by the input unit 11 to shift to the form creating mode, the CPU 14 executes a form creating process, which will be described later, based on the data and the input instruction input from the input unit 11. Form data is created in the memory 16. In this form creation process, the CPU 14
Only when the reference table is set in advance by the reference table setting process for the input item designated by the cursor, based on the reference table by the item data reference function, for example, a sub-window as shown in FIG. Is generated and displayed on the display unit 15.

The display unit 15 is a CRT (Cathode Ray Tub).
e) and a liquid crystal display, etc.
Key input data input via the keypad 14, form data expanded from the record file 13 to the work memory 16, and the like are displayed on the display screen.

The work memory 16 forms a memory area for temporarily storing various data to be processed when the CPU 14 executes various control processes. A selection content storage table is stored in the work memory 16, and a plurality of desired item data are selected from the reference data listed in the sub-window by the item data reference function in the form creation process described later. Then, the selected item data are stored in the selected content storage table in the order of selection.

An example of the selection content storage table stored in the work memory 16 is shown in FIG. The selection content storage table shown in FIG. 3 is displayed in the sub-window displayed based on the reference table shown in FIG. 5 by the item data reference function when the delivery slip shown in FIG. This is used when a plurality of item data is selected.

This selection content storage table is composed of a selection order field and a product name field. In the selection order field, when item data is selected by the operator from the sub-window, it is sequentially incremented from "1". Stored values are stored as selection order data. In the item name field, item name data selected from the sub-window is stored in the order of selection.

The form definition memory 17 has a memory area for temporarily storing a form definition table in which the form form of the form data being processed and the attribute information of the item data constituting each record of the form data are stored. Form.
An example of the form definition table expanded in the form definition memory 17 is shown in FIG. The form definition table shown in FIG.
It is used when creating the delivery slip shown in FIG. 9, and is composed of an item field, a digit number field, and an attribute field.

The item field stores the item name data of each item constituting the record, and the digit number field stores the number of inputtable characters of the item data input to each item. The attribute field stores attribute information of item data input to each item.

The attribute information stored in this attribute field indicates the data form of the item data. For example, "input" stored in the attribute field of the form definition table of FIG. Input section 1
1a means that the data is input, and "calculation (quantity x unit price)" is data obtained by calculation from the data values stored in the quantity item and unit price item of the same record. I mean. Further, “selection (from reference table)” means data selected from a reference table described later, and “reference (from product name)” is based on data stored in the product name item of the same record. , Which means that the data is obtained by referring to a reference table described later.

The table file 18 stores a memory area for storing a plurality of the above-mentioned various form definition tables expanded in the form definition memory 17, reference data displayed in a sub window by the item data reference function, and related information thereof. And a memory area for storing a plurality of reference tables.

The reference table is created by the reference table setting process described later and stored in the table file 18. FIG. 5 shows an example of the reference table stored in the table file 18. The reference table shown in FIG. 5 uses the item data reference function to display the sub-window shown in FIG. 2 when the operator designates a product name item as an input item with the cursor when creating the delivery slip shown in FIG. 9 by the form creation process described later. The item name data displayed in a list and the unit price data which is the related information are stored.

This reference table is composed of a product name field and a unit price field, and the product name field stores frequently used product name data which is often used when creating the delivery slip. In the unit price field, unit price data corresponding to the product name data stored in the product name field is stored. The above is the configuration of the computer system 1 according to the present embodiment.

Next, the operation will be described. First, the reference table setting process executed by the CPU 14 of the computer system 1 according to the present embodiment will be described based on the flowchart shown in FIG.

The reference table setting process creates a reference table for storing the item data displayed in the subwindow by the item data reference function and its related information, and sets the environment of the item data reference function based on the reference table. This is a process to be performed, and when the input unit 11 gives an instruction to shift to the reference table setting mode, the ROM
The program relating to the reference table setting processing stored in 12 is read and the processing is started.

First, the CPU 14 causes various form data (for example, various form data processed in the computer system 1).
It prompts the operator to input the form data type for which form data type the reference table is set, such as an order receipt, a delivery slip, or a pay slip slip.
Then, when the operator inputs the form data type (step S1), the CPU 14 reads out the form definition table of the input form data type from the table file 18 and expands it in the form definition memory 17 (step S1).
2).

Next, the CPU 14 causes the form definition memory 1
With respect to the form definition table expanded to 7, the item name data stored in the item field is displayed on the display unit 15, and for which item the reference table is set, that is, which operator the operator is creating the form data. When an item is specified, the item data reference function is activated and a subwindow based on reference data to be created is displayed, or the operator is prompted to input the item type.
Then, when the operator inputs the item type (step S3), the CPU 14 determines the field configuration of the reference table to be created based on the predetermined field setting standard (step S4).

Here, the predetermined field setting standard is, for example, when the reference table is set, "delivery slip" is specified as the form data type and "product name item" is specified as the item type by the operator. In this case, as can be seen from the delivery slip shown in FIG. 9, when the item name item data is determined, the value of the unit price item data is also determined accordingly. Therefore, the reference table is used for the item name data of the delivery slip. When setting, the reference table field structure should be the product name field and unit price field, etc.
It defines the field setting criteria of the reference table created for each item type.

Next, the CPU 14 causes the above-mentioned step S4.
The operator is prompted to input each field data based on the field configuration of the reference table determined in (3), and when the operator inputs each field data (step S5), based on the input data,
A reference table is created in the work memory 16 (step S6).

Then, the CPU 14 determines the form definition memory 17 based on the field structure of the created reference table.
After setting the environment of the item data reference function so that the item data reference function based on the created reference table can be started, such as modifying the data stored in the attribute field of the form definition table expanded in ( S
7) The reference table created in the work memory 16 is stored in the table file 18 (step S8), and the reference table setting process ends. The above is the operation procedure of the reference table setting process executed by the CPU 14 of the computer system 1 according to the present embodiment.

Next, the form creating process executed by the CPU 14 of the computer system 1 according to the present embodiment will be described with reference to the flowcharts shown in FIGS. 7 and 8 and FIGS. 9 to 14. In the form creation process, when an instruction to shift to the form creation mode is given from the input unit 11, a program related to the form creation process stored in the ROM 12 is read and the process is started.

First, the CPU 14 prompts the operator to input the form data type for which form data type of the various form data processed in the computer system 1 the form data is created. And
When the operator inputs the form data type (step S11), the CPU 14 reads the form definition table of the input form data type from the table file 18 and expands it in the form definition memory 17, and based on the form definition table. For example, the form form as shown in FIG. 9 is displayed on the display unit 15 (step S12), and the work memory 16 secures a memory area for creating the form data.

Next, the CPU 14 determines whether or not the input section 11 has instructed to shift to the item data input mode (step S13), and when it has not instructed to shift to the item data input mode. , After processing based on the instruction from the input unit 11 (step S1
4) Then, the form creating process is terminated. Also, the CPU 14
If it is determined in step S13 that the instruction to shift to the item data input mode is instructed, then it is determined whether or not the input item position (row, column) is designated by the cursor (step S15). If the input item position is not specified, then it is determined whether or not the key input unit 11 has instructed to end the form creation process (step S16).

The CPU 14 then executes the above step S1.
In step 6, if it is determined that the instruction to end the form creation processing is not instructed, the process returns to step S15. If it is determined that the instruction to end the form creation processing is instructed, the form creation is performed. Finish the process

On the other hand, the CPU 14 causes the above step S15.
If it is determined that the input item position has been designated, then it is determined whether or not a reference table is set for the input item (step S17). When the CPU 14 determines that the reference table is not set for the input item, the CPU 14 prompts the operator to input the item data, and the operator inputs the item data via the input unit 11. (Step S1
8) After storing the item data in the work memory 16 as item data of the designated input item (step S19), the process returns to step S15, and a new input item position (row, column) is designated by the cursor. It is determined whether or not.

The CPU 14 also executes the above step S17.
When it is determined that the reference table is set for the input item in step S1, the reference table set for the input item is read from the table file 18 and expanded in the work memory 16 (step S20). ,
A sub-window based on the item data reference function is displayed on the display unit 15 based on this reference table (step S2).
1).

For example, as shown in FIG. 10, when the item name item is designated by the cursor 21 in the delivery slip, if the reference table shown in FIG. 5 is preset for the item name item, this reference table is set. Based on the item data reference function, the sub-window 22 is displayed on the display unit 15.
Will be displayed.

Next, the CPU 14 determines whether or not the item data is selected from the item data listed in the sub window (step S22). If the item data is not selected, the CPU 14 selects the item from the sub window. Continue monitoring whether item data is selected. When the CPU 14 determines in step S22 that item data has been selected, the CPU 14 reversely displays the selected item data portion in the sub-window and displays the selected item data and its selection order data in the work memory 16. It is stored in the selection content storage table (step S23).

Then, the CPU 14 determines whether or not the return key has been pressed (step S24). If the return key has not been pressed, the CPU 14 returns to step S22. The CPU 14 also executes the above step S2.
If it is determined in step 4 that the return key has been pressed, the sub-window displayed on the display unit 15 is erased, and the process proceeds to step S31 in FIG.

By the processing of steps S22 to S24, it becomes possible to select a desired plurality of item data from the item data displayed in the list in the sub-window, and the selected item data are selected according to the selection order. It becomes possible to store in the selection content storage table of the work memory 16.

Next, the CPU 14 reads the final selection order data value stored in the selection order field of this selection content storage table, and reads the final selection order data value from the record including the input item designated by the cursor. It is determined whether or not there are the same number of subsequent records for which no data has been input at the designated input item positions (step S3).
1). Then, when the CPU 14 determines that there is not the same number of subsequent records as the final selection order data value from the record including the designated input item, that is, when it is determined that there is a shortage of records, the record of the shortage is insufficient. After newly generating (step S32), step S3
Move to 3.

The CPU 14 also executes the above step S31.
In step S32, if it is determined that there are the same number of subsequent records as the final selection order data value from the record including the designated input item, that is, if it is determined that the records are not insufficient, the step S32 is skipped and the step The process moves to S33. Next, the CPU 14 causes the C
The initial value "1" is stored in the count register C (not shown) provided inside the PU 14 (step S33). continue,
The CPU 14 reads the selection item data having the value stored in the count register C as the selection order number from the selection content storage table of the work memory 16.

Then, the CPU 14 uses the record including the input item designated by the operator as a reference, and sequentially selects the selected item data for each record subsequent to the reference record, in which no data has been input at the designated input item position. The read selection item data is input to the designated input item position of the corresponding record so that the items are stored in the selected order (step S34). Next, the CPU 14 checks the attribute field of the form definition table expanded in the form definition memory 17, refers to the reference table based on the selection item data in the record in which the selection item data is input, and inputs the data. It is determined whether or not there is a reference item (step S35).

If the CPU 14 determines that the record has a reference item, it reads the corresponding item data from the reference table based on the selection item data and inputs it to the reference item (step S36). Also, C
When the PU 14 determines in the above step S35 that the record has no reference item, the above described step S
Without performing 36, the process proceeds to step S37.

Next, the CPU 14 rewrites the value stored in the count register C with the incremented value (step S37), and then, in the selection content storage table of the work memory 16, stores the value stored in the count register C. It is determined whether or not the selection item data to be the selection order number is stored (step S38), and if the corresponding selection item data exists, the process returns to step S34. If the CPU 14 determines in step S38 that the corresponding selection item data does not exist, the process returns to step S15 in FIG.

By the processes of steps S33 to S38, the record including the input item designated by the operator is used as a reference, and the records subsequent to the reference record, in sequence, have no data input at the designated input item position. , It becomes possible to input each selection item data according to the selection order.

Here, the form creating process is described with reference to FIGS.
A specific description will be given based on an item data input example using the item data reference function shown in FIG. It should be noted that the following description is for the case where the delivery slip shown in FIG. 9 is created, and the reference table shown in FIG. 5 is created in advance by the reference table setting process described above. It is assumed that the item data reference function based on the reference table is established.

For example, as shown in FIG. 11A, the cursor 21 is displayed when no record is generated.
The item name item is designated by, the sub window 22 is displayed by the item data reference function, and the operator selects "calculator" and "TV" from the sub window 22.
When the two item data of are selected, the CPU 14
In the above step S31, it is determined that two records are insufficient because there is no record at all, and two records in the first stage and the second stage in the figure are generated (step S32).

Then, as shown in FIG. 11B, the CPU 14 sets the item data "calculator" selected first in the product name item of the first record in the figure in the two generated records. Further, the item data "TV" selected next is input to the item name item of the second record in the figure (step S34), and read out from the reference table shown in FIG. 5 based on the selected item data. , Unit price data “2500” and “27500” are input to the unit price items of the respective records (step S36).

As shown in FIG. 12 (a), when the other item data is already input, the cursor 21
The item name item is designated by, the sub window 22 is displayed by the item data reference function, and the operator selects "calculator" and "TV" from the sub window 22.
When the two item data of are selected, the CPU 14
In step S31, it is determined that there is no shortage of records.

Then, the CPU 14 does not generate a new record and, as shown in FIG.
Enter the item data “Calculator” selected first in the item name item of the second record, and the item data “TV” selected next in the item name item of the second record in the figure ( Step S34), the unit price data "2500" and "27500" read out from the reference table shown in FIG. 5 based on the selected item data are input to the unit price items of the respective records (Step S).
36).

Further, in the state shown in FIG. 13A, the item name item of the first record in the drawing is designated by the cursor 21, the sub-window 22 is displayed by the item data reference function, and the sub-window 22 of the sub-window 22 is displayed. When the operator selects two item data of "calculator" and "television" from the inside, the CPU 14 determines in step S31 that one record is missing, and a new record (two rows in the figure). One eye is generated (step S32).

Then, as shown in FIG. 13B, the CPU 14 sets the item data item "calculator" selected first in the item name item of the first record in the figure, and the second item in the figure. The item data “TV” selected next is input to the item name item of the record (step S34), and the unit price data “2500” read out from the reference table shown in FIG. 5 based on the selected item data. And "2
7500 "is input to the unit price item of each record (step S36).

In addition, in the state as shown in FIG. 14A, the item name item of the first record in the figure is designated by the cursor 21, the sub-window 22 is displayed by the item data reference function, and the sub-window 22 concerned is displayed. When the operator selects two item data of “calculator” and “television” from among the above, the CPU 14 determines in step S31 that one record is insufficient, and a new record (4 in the figure). One row is generated (step S32).

Then, as shown in FIG. 14B, the CPU 14 sets the first selected item data "calculator" in the item name item of the first record in the figure, and the fourth item in the figure. The item data “TV” selected next is input to the item name item of the record (step S34), and the unit price data “2500” read out from the reference table shown in FIG. 5 based on the selected item data. And "2
7500 "is input to the unit price item of each record (step S36). The above is the operation procedure of the form creation process executed by the CPU 14 of the computer system 1 according to the present embodiment.

In the above-described form creation process, when sequentially inputting each selection item data in the designated input item position of each record according to the selection order, the record including the input item designated by the cursor is used as a reference, Although it is configured to sequentially input to each record in which data has not been input at the designated input item position subsequent to the reference record, this is not limited to the above content, and for example, key input In response to an instruction input via the unit 11,
Needless to say, the structure may be such that data is not input at the designated input item position preceding the reference record in order.

Further, in the above-mentioned form creation processing, it is possible to select a plurality of the same item data from the sub-window displayed by the item data reference function. in this case,
In the above-described form creation process, it is desirable to change the reverse display color of the item data portion selected in the sub-window, for example, white for the first time, blue for the second time, green for the third time, and the like. The above is the description of the first example of the embodiment of the computer system to which the record data input device of the present invention is applied.

From the above, in the computer system 1 according to the present embodiment, when a desired plurality of item data is selected from the plurality of item data displayed in the sub-window by the item data reference function,
It is possible to input the selection item data in the designated input item positions of the respective records in the records in which the data is not input in the designated input item positions as many as the selection items.

Therefore, in the item data reference function, it is possible to select and input a plurality of item data at a time, so that it is possible to reduce the work load on the operator for data input when creating the form data.

Further, in the computer system 1 according to the present embodiment, when a desired plurality of item data is selected from the plurality of item data displayed in the sub window by the item data reference function, the number of selected items is It is possible to determine whether or not there is the same number of records for which no data has been input at the designated input item position, and if there are not the same number of records as the number of selected items, it is possible to generate the insufficient number of records. .

Therefore, since it is not necessary for the operator to instruct the creation of the deficient records, it is possible to reduce the work load on the operator for data input when creating the form data.

Next, a second example of the embodiment of the computer system to which the record data input device of the present invention is applied will be described with reference to FIGS. First, the configuration will be described.

FIG. 15 is a block diagram showing the overall configuration of the computer system 2 in the second example of the embodiment. The same components as those of the computer system 1 shown in FIG. 1 have the same reference numerals. Is attached.
15, the computer system 2 includes the input unit 11, the ROM 12, the record file 13, the display unit 15, the form definition memory 17 and the table file 18 shown in FIG. 1, the CPU 31 and the work memory 32. There is.

The CPU 31 controls the computer system 2 according to various control programs stored in the ROM 12.
Control each part of Specifically, when the input unit 11 instructs the CPU 14 to shift to the reference table setting mode, the CPU 14 executes the above-described reference table setting process and, based on the data input from the input unit 11, the work memory. After creating a reference table in 31 and setting the environment of the item data reference function based on the reference table, the reference table is stored in the table file 18.

When the input section 11 instructs the CPU 31 to shift to the form creation mode, the CPU 31 executes a form creation process, which will be described later, based on the data and the input instruction input from the input section 11. Form data is created in the memory 31. In this form creation process, the CPU 31
Only when the reference table is set in advance by the reference table setting process for the input item designated by the cursor, based on the reference table by the item data reference function, for example, a sub-window as shown in FIG. Is generated and displayed on the display unit 15.

The work memory 32 forms a memory area for temporarily storing various data processed when the CPU 14 executes various control processes. A selection content storage table is stored in the work memory 32, and a desired plurality of item data are selected from the reference data listed in the sub-window by the item data reference function in the form creation process described later. At the same time, when the quantity of each selected item is input, the selected item data and the quantity data thereof are stored in the selected content storage table in the order of selection of the item data.

FIG. 17 shows an example of the selection content storage table stored in the work memory 32. The selection content storage table shown in FIG. 17 is displayed in the sub-window displayed based on the reference table shown in FIG. 5 by the item data reference function when the delivery slip shown in FIG. This is used when a plurality of item data is selected and the quantity data of each selected item data is input.

This selection content storage table is composed of a selection order field, a product name field and an input number field. When the operator selects item data from the sub-window in the selection order field, "1" is displayed. Values sequentially incremented from are stored as selection order data. The item name field stores the item name data selected from the sub-window in the order of selection, and the input number field stores the quantity data of the selected item name data.
The above is the configuration of the computer system 2 in the second example of the embodiment.

Next, the operation will be described. The reference table setting process executed by the CPU 31 of the computer system 2 according to the present embodiment is the same as the reference table setting process (flowchart: FIG. 6) according to the first example of the above-described embodiment, and therefore description thereof will be omitted. .

Next, the form creating process executed by the CPU 31 of the computer system 2 according to the present embodiment will be described with reference to the flowcharts shown in FIGS. 18 and 19 and FIGS. 20 to 22. Note that the form creation process has substantially the same processing procedure as the form creation process in the first example of the above-described embodiment, so in the following description, the characteristic parts of this embodiment will be described. I will focus on this.

First, in the form creating process, the process procedure from step S41 to step S49 is the same as the process procedure in step S11 to step S19 of the form creating process in the first example of the above-described embodiment. .

The CPU 31 determines in step S47 that
It is determined whether or not the reference table is set for the input item designated by the cursor (step S4).
7) If it is determined that the reference table is set for the input item, the reference table set for the input item is read from the table file 18 and expanded in the work memory 32 (step S50). ), Based on this reference table, a sub-window with the item data reference function is displayed on the display unit 15 (step S5).
1).

For example, as shown in FIG. 20, when the item name item is designated by the cursor 21 in the delivery slip, if the reference table shown in FIG. 5 is preset for the item name item, this reference table is set. Based on the item data reference function, the sub window 33 is displayed on the display unit 15.
Will be displayed.

Next, the CPU 31 determines whether or not item data is selected from the item data listed in the sub window (step S52). If no item data is selected, the CPU 31 selects from the sub window. Continue monitoring whether item data is selected. When the CPU 31 determines in step S52 that item data has been selected, it highlights the item data part selected in the sub-window and then determines whether the quantity data of the selected item data has been input. It is determined whether or not (step S53).

When the CPU 31 determines that the quantity data of the selected item data has not been input,
Whether or not the quantity data of the selection item data is input is continuously monitored, and when it is determined that the quantity data of the selection item data is input, the selection item data and the quantity data thereof are selected. It is stored in the selection content storage table of the work memory 32 together with the sequence data (step S54). Then, the CPU 31 determines whether or not the return key has been pressed (step S5).
5) If the return key has not been pressed, the process returns to step S52. If the CPU 31 determines in step S55 that the return key has been pressed, it erases the sub-window displayed on the display unit 15 and proceeds to step S61 in FIG.

By the processing of steps S52 to S55, it becomes possible to select a desired plurality of item data from the item data displayed in a list in the sub-window and to input the quantity data of each selected item data. Further, it becomes possible to store each selection item data and the quantity data thereof in the selection content storage table of the work memory 32 according to the selection order.

Then, the CPU 31 calculates the total sum of the respective quantity data stored in the input number field of this selection content storage table, and calculates the calculated quantity data from the record including the input item designated by the cursor. It is determined whether or not there are subsequent records for which no data has been input at the designated input item positions, the number of which is the same as the total sum of (step S).
61). Then, when the CPU 31 determines that there is not the same number of subsequent records as the total sum of the respective quantity data from the record including the designated input item, that is, when it is determined that there is a shortage of records, the shortage amount is calculated. After newly creating a record (step S62), the process proceeds to step S63.

The CPU 31 also executes the above step S61.
When it is determined that there are the same number of subsequent records as the total sum of the respective quantity data from the record including the designated input item, that is, when it is determined that the records are not insufficient, the step S62 is not performed. Control goes to step S63. Next, the CPU 31 has a count register C (not shown) provided inside the CPU 31.
The initial value "1" is stored in (step S63). Then, the CPU 31 reads the selection item data having the value stored in the count register C as the selection order number from the selection content storage table of the work memory 32.

Then, the CPU 31 uses the record including the input item designated by the operator as a reference, and sequentially selects the selection item data for each record subsequent to the reference record in which no data has been input at the designated input item position. The read selected item data is input to the designated input item position of the corresponding record so that each item can be contained in the selected order by the respective quantity data (step S64). Next, the CPU 31 checks the attribute field of the form definition table expanded in the form definition memory 17, refers to the reference table based on the selection item data in the record in which the selection item data is input, and inputs the data. It is determined whether there is a reference item (step S6).
5).

When it is determined that the record has a reference item, the CPU 31 reads the corresponding item data from the reference table based on the selection item data and inputs it to the reference item (step S66). Also, C
If the PU 31 determines in step S65 that there is no reference item in the record, the PU 31 executes step S65.
Without performing 66, the process proceeds to step S67. Then
Regarding the selection item data read from the selection content storage table of the work memory 32, the CPU 31 determines whether or not the selection item data has been input by the quantity data (step S67), and the selection item data is input by the quantity. If not, the process returns to step S64.

When the CPU 31 determines that the quantity of the selected item data has been input, the CPU 31 then rewrites the value stored in the count register C to the incremented value (step S68), and then the work memory. Three
In the selection content storage table of No. 2, it is determined whether or not the selection item data having the value stored in the count register C as the selection order number is stored (step S6).
9). Then, when the CPU 31 determines that the corresponding selection item data exists, the process returns to step S64, and when the CPU 31 determines that the corresponding selection item data does not exist, the process returns to step S45 of FIG.

By the processes of steps S63 to S69, the record including the input item designated by the operator is used as a reference, and the records in which no data has been input at the designated input item position are successively recorded from the reference record. , It becomes possible to input each selection item data by the quantity data according to the selection order.

Here, the form creation process will be described with reference to FIGS.
A specific description will be given based on an item data input example using the item data reference function shown in FIG. It should be noted that the following description is for the case where the delivery slip shown in FIG. 9 is created, and the reference table shown in FIG. 5 is created in advance by the reference table setting process described above. It is assumed that the item data reference function based on the reference table is established.

For example, as shown in FIG. 21A, the cursor 21 is displayed when no record is generated.
The item name item is specified by, the sub window 33 is displayed by the item data reference function, and the operator selects "Calculator" and "TV" from the sub window 33.
When two item data of are selected and “2” and “1” are input as the respective quantity data,
In step S61, the CPU 31 determines that there are not three records because there is no record, and generates a total of three records from the first stage to the third stage in the figure (step S62). .

Then, as shown in FIG. 21B, the CPU 31 selects the item data “first selected” in the product name items of the first and second records in the figure among the three generated records. "Calculator" and the item name item "TV" selected next in the item name item of the third record in the figure (step S64), and as shown in FIG. 5 based on the selected item data. Unit price data “2500” and “27” read from the table
"500" is input to the unit price item of each record (step S66).

Further, in the state shown in FIG. 22A, the item name item of the first record in the drawing is designated by the cursor 21, the sub-window 33 is displayed by the item data reference function, and the sub-window 33 is displayed. When the operator selects two item data of “calculator” and “television” from the inside and “2” and “1” are input as the respective quantity data, the CPU 31
Determines that two records are insufficient in step S61, and generates two new records (fourth and fifth rows in the figure) (step S62).

Then, as shown in FIG. 22B, the CPU 31 sets the item data "calculator" selected first in the item name items of the first and fourth records in the drawing, and also in the drawing. The item data "TV" selected next is input to the item name item of the fifth record (step S6).
4), the unit price data “250” read from the reference table shown in FIG. 5 based on the selected item data.
"0" and "27500" are entered in the unit price items of each record (step S66). The above is the operation procedure of the form creation process executed by the CPU 14 of the computer system 2 according to the present embodiment.

In the above-described form creation process, when the respective selection item data are sequentially input to the designated input item position of each record in the order of selection, the input items designated by the cursor are input. With the record that contains it as a reference, the subsequent records in order from the reference record,
Data is input to each record in which data has not been input at the designated input item position. However, this is not limited to the content described above, and for example, in response to an instruction input via the key input unit 11. As a matter of course, the structure may be such that the records are sequentially input from the reference record, to the preceding records, to which the data has not been input at the designated input item position. The above is the description of the second example of the embodiment of the computer system to which the record data input device of the present invention is applied.

As described above, in the computer system 2 according to the present embodiment, a plurality of desired item data are selected from the plurality of item data displayed in the sub-window by the item data reference function, and When the quantity of each of the selection item data is input, the same number of records as the sum of the quantities of the selection item data is input to the specified input item position of each record in the record where data is not input to the specified input item position. It is possible to input each selection item data according to each quantity.

Therefore, in the item data reference function, it is possible to input the selected item data into the form data being prepared for each quantity. Therefore, when creating the form data, the work load on the operator for data input can be reduced. You can

Further, in the computer system 2 according to the present embodiment, a desired plurality of item data are selected from the plurality of item data displayed in the sub-window by the item data reference function, and each selected item data is selected. When the number of items is input, it is determined whether or not there are records for which no data has been input at the specified input item position, the number of which is the same as the total number of items of the selected item data. If there is not the same number of the records as described above, it becomes possible to generate the insufficient number of the records.

Therefore, since it is not necessary for the operator to instruct the creation of the deficient records, it is possible to reduce the work load of the operator on the data input when creating the form data.

Although the present invention has been specifically described based on the first and second examples of the embodiment, the present invention is not limited to the above-described embodiment and does not depart from the scope of the invention. Needless to say, it can be changed appropriately.

For example, the first and second examples of the above embodiment
In the example, the case where the record data input device of the present invention is applied to the form management computer system is described. However, the present invention is not limited to the above contents, and is applied to, for example, a database management computer system. Of course, you can do so.

In addition, in the first and second examples of the above-described embodiment, when displaying the reference data composed of a plurality of item data preset by the item data reference function,
Although a sub-window is used, the display form of the reference data is not limited to the sub-window. In short, if reference data set in advance is displayed and desired data can be selected from among them, It can be anything.

[0105]

According to the invention of claim 1, in the item data reference function, a plurality of item data are selected at a time,
Since the data can be entered, it is possible to reduce the work load of the operator regarding the data entry when creating the form data.

According to the second aspect of the present invention, in the item data reference function, the selected item data can be input into the form data being created for each quantity. Therefore, when creating the form data, It is possible to reduce the operator's work load related to input.

Further, according to the invention described in claim 3, since it is not necessary for the operator to instruct creation of the insufficient records by himself / herself, it is possible to reduce the work load of the operator concerning the data input when creating the form data. Become.

[Brief description of the drawings]

FIG. 1 is a block diagram of a computer system to which the present invention is applied.

FIG. 2 is a diagram showing an example of a subwindow displayed by an item data reference function.

FIG. 3 is a diagram showing a configuration of a selection content storage table expanded in the work memory of FIG.

FIG. 4 is a diagram showing an example of a form definition table expanded in the form definition memory of FIG.

5 is a diagram showing an example of a reference table stored in the table file of FIG.

FIG. 6 is a flowchart of a reference table setting process executed by the CPU of FIG.

FIG. 7 is a flowchart (part 1) of the form creation process executed by the CPU of FIG.

8 is a flowchart (No. 2) of the form creation process executed by the CPU of FIG.

9 is a diagram showing a form form displayed based on the form definition table shown in FIG.

10 is a diagram showing a sub-window displayed by the item data reference function based on the reference table shown in FIG.

FIG. 11 is an example (1) of inputting item data using an item data reference function.

FIG. 12 is an example (2) of inputting item data using the item data reference function.

FIG. 13 is an example of inputting item data using an item data reference function (No. 3).

FIG. 14 is an example (4) of inputting item data using the item data reference function.

FIG. 15 is a block configuration diagram of a computer system according to a second example of the embodiment.

FIG. 16 is a diagram showing an example of a sub-window displayed by the item data reference function in the second example of the embodiment.

17 is a diagram showing the configuration of a selection content storage table expanded in the work memory of FIG.

FIG. 18 is a flowchart (part 1) of the form creation process executed by the CPU of FIG.

FIG. 19 is a flowchart (part 2) of the form creation process executed by the CPU of FIG.

20 is a diagram showing a sub-window displayed by the item data reference function based on the reference table shown in FIG. 5 in the second example of the embodiment.

FIG. 21 is an example (1) of inputting item data using the item data reference function in the second example of the embodiment.

FIG. 22 is an item data input example (part 2) using the item data reference function in the second example of the embodiment.

[Explanation of symbols]

 1 computer system 2 computer system 11 input section 11a key input section 11b mouse 12 ROM 13 record file 14 CPU 15 display section 16 work memory 17 form definition memory 18 table file 21 cursor 22 subwindow 31 CPU 32 work memory 33 subwindow

Claims (3)

[Claims] 1. A record data input device for inputting record data composed of a plurality of item data, wherein when inputting the record data, a plurality of item data is set in advance for a designated input item. If there is, a setting item display means for displaying a list of the plurality of item data, and a selection control for controlling a plurality of desired item data from the plurality of item data displayed by the setting item display means. And a plurality of item data items are selected under the control of the selection control unit, the number of the selected items is the same as the number of the selected item items in the designated input item position where no data has been input. A record data input device comprising: item data input means for inputting each of the selection item data at an input item position; Place. 2. The selection control means controls a plurality of desired item data from the plurality of item data displayed in a list by the setting item display means so that the desired plurality of item data can be selected. When the quantity of each selected item data is input while a plurality of item data is selected under the control of the selection control means, the item data input means In the same number as the total of the quantity of each selection item data, in the record in which the data has not been input in the specified input item position, input the selection item data in the specified input item position of each record according to each quantity. The record data input device according to claim 1, wherein 3. When a plurality of item data are selected under the control of the selection control means, and the number of the selected items is the same as the number of the selected input items, and there is no data-uninput record, The record data input device according to claim 1 or 2, further comprising a record generation unit that generates the record of the shortage.