Blank records showing when browse

[acorbally]

I have seen randomly throught my program on various cases that some will display as though they have a blank record. When you look in the db I don't see the blank record. I create a relationship then do a

BROWSE NORMAL NODELETE TITLE "Case List by Patient ID" ;
NOAPPEND NOMENU NOEDIT FONT 'MS Sans Serif',8 ;
FIELDS recipien.pat_id, recipien.pat_lstnam, recipien.pat_fstnam, drugpa.drug_name, drugpa.reqst_date,drugpa.appden ;
KEY m.pat_id

It shows those records as such
PAT_ID PAT_LSTNAM PAT_FSTNAM DRUG_NAME REQST_DATE
1111111 Brown Jane Tylenol 01/01/01
******* ******** ******* Asprin 06/06/06
******* ******** ******* / /

As you can see in the third record it is all blanks. There are are only two records in the db one for Tylenol and one for Asprin. So why is the third showing?

 

[JRB-Bldr]

You are browsing against two related data tables.
Recipien
Drugpa

Is there one or more matching record(s) in the "child" table for each and every "parent" table record?

If you have set your record pointer to the "parent" table prior to the Browse and you have non-matching "child" records then those "child" fields will show as blank in the Browse when the "parent" table record is displayed.

Good Luck,


JRB-Bldr
VisionQuest Consulting
Business Analyst & CIO Consulting Services
CIOServices@yahoo.com