DATAFILE?

OPTION?ADD

ITEM 1 ? /VIRTUAL

Foreign Data File? common_file // file where foreign filed imported from

Field in current file to key on? studentid //common key field in primary &foreign files

Foreign field identifier? cellphone // which field imported from foreign file

Text Box: studentid Text Box: studentid Look-up key identifier <Primary key>? enter

DKB200:[REG.FILES]

2. IMPORT PROMTP.BCF INTO SOURCE.BCF
-Edit filename.ext
- Place the cursor where you want to import PP.TXT
- Press NumLock ->7 => Command line appear at bottom
* Command: Include DKB200:[SLIM]PP.TXT //Get Papertype& Printer, all code shown

* F10

3. IMPORT VAR=value and PROMPT VALUE for variable

$ run dms:sort
inventory
.dept

yes
.price
<@Enter the Low Price Range: Ex. 400@>
<@Enter the High Price Range: Ex. 9999@>
OR

*EQUATE <DPT1$> <<@ENTER FIRST DEPARTMENT@>>
*EQUATE <DPT2$> <<@ENTER NEXT DEPARTMENT@>>
*EQUATE <DPT3$> <<@ENTER NEXT DEPARTMENT@>>

4: IMPORT DATA INTO EXEL
a.ASQ> find current...
b.Run FTP > Set to ASNCII before transfering file
c.Open Excel, -> DATA->IMPORT EXTENDED DATA -> Semicolon;
finish