[Easy to fly] information transfer-Multiple tables (including appearances) associated values

[Abstract] Quality department proposed rosh information management needs: input incoming inspection single time, take the system exterior product number supplier material corresponding * * Test date, effective date, warning date * *.
Solution:
1. Create a new Rosh basic information table and provide a maintenance program Interface
2. Customize the screen Design extension field and take advantage of the 9.0 information transfer function to bring out the data.

First, the basic data table
Because there may be more than one set of books to use to this base data, in order to save costs. To create a new Rosh table in a standalone database OA:
CREATE TABLE [dbo]. [ROSH] (
[ID] [int] IDENTITY (*) Not NULL,
[Company] nchar NULL,
[Supplier] nvarchar NULL,
[suppliername] nvarchar NULL,
[Item] nvarchar NULL,
[itemname] nvarchar NULL,
[ItemSpec] nvarchar NULL,
[Material] nvarchar NULL,
[TestDate] [DateTime] Null
[Effectivedate] [DateTime] Null
[Warningdate] [DateTime] Null
CONSTRAINT [pk_rosh_1] PRIMARY KEY CLUSTERED
(
[Id] ASC
) with (Pad_index = off, Statistics_norecompute = off, Ignore_dup_key = off, Allow_row_locks = on, allow_page_locks = ON) O N [PRIMARY]
) on [PRIMARY]

GO
Second, design maintenance interface

Third, the design of self-setting screen

Iv. Input Data Sheet
Setting up information transfer only recognizes tables in the input data table.
Create a View
CREATE VIEW [dbo]. [ROSH]
As
SELECT Id, Company, Supplier, SupplierName, Item, ItemName, ItemSpec, Material, TestDate, Effectivedate, warningdate
From OA.dbo.ROSH as rosh_1
WHERE (company = ' ZM ')

GO
Input data Sheet Rosh

Five. Set up information delivery
Since the incoming inspection order does not have a vendor code and a Product number field (which is a display value), setting information delivery settings can only be associated with one table. Do how
Since there is no value, can you bring out the value first and save it.

Z01 bring out the supplier and product number.
S01 associated Rosh table fetching data.

Six, verification.
1. New take out single header information

2. Audit
Input material: 70g33l, Audit

Finished, I hope you will advise. Thank you.