ghost record

[Slobey]

Hi,

I have a portal in my solution with a number of calculation fields. 2 of these calc fields show $0.00 on the last row which is not a record.

The fields:

Desc Bid Price=

"Desc Cost + Desc MU Amt" &

Total Desc Bid Pre=

"Desc Bid Price * Quantity"

show $0.00 on the last row.

The fields:

Total Desc Cost =

"Desc Cost * Quantity" &

Total MU =

"(Desc M U Entry / 100) * Total Desc Cost"

show nothing.

All fields have same number format: format as decimal, fixed number of 2, $ notation, use thousands separator.

How can I get rid of the ghost $0.00 and what makes them appear on some calcs and not on others

[Ugo DI LUCA]

Hi,

Your portal is set with "allow creation of related records" I would think.

check databasepros for a trick for 7, or do a search here with "ghost" as a key field as this was already covered in the past.

[Slobey]

I did the search but came up with nothing

[Ugo DI LUCA]

Hi,

There are a lot of posts hre xwith either "ghost" or "phantom".

One I can recall of is :

http://www.fmforums.com/threads/showflat.php?Cat=0&Board=UBB17&Number=57595

[Ugo DI LUCA]

and here for 3 techniques....

http://www.filemakerpros.com/NEWROW.zip

[Slobey]

Thank you,

the Databse pro link helped alot. But just out of curiousity, why do 2 of my fields stay blank and the other 2 have the $0.00 in them?

[Ugo DI LUCA]

Hi,

"do not evaluate if empty" should be checked in the calc definition.

[Joe Stroll]

From Filemaker Pro 7 Article 108661, I typed into Scriptmaker this script.

It works but gives me essential ALL the duplicates. I need to see only records with 2 or more duplicates.

Where do I need to modify this script to make it work?

Thank you in adance for your help

Enter Find Mode [ ]

Set Field ["CountDups",""> " & GlobalDupsOK"]

Perform Find [Replace Found Set]

Sort [Restore, No dialog]

Pause/Resume Script [ ]

Go to Record/Request/Page [First]

Loop

Set Field ["GlobalOmit","GlobalDupsOK"]

Loop

Exit Loop If ["GlobalOmit=0"]

Omit Record

Set Field ["GlobalOmit","GlobalOmit-1"]

End Loop

Set Field ["GlobalCounter","CountDups - GlobalDupsOK"]

Loop

Exit Loop If ["GlobalCounter=0"]

Go to Record/Request/Page [Exit after last, Next]

Set Field ["GlobalCounter","GlobalCounter-1"]

End Loop

Exit Loop If ["Status(CurrentRecordNumber)=Status(CurrentFoundCount)"]

End Loop

[Ugo DI LUCA]

Joe,

Welcome to the Forums.

You're posting in the wrong Forum, in an already opened thread with a totally different topic.

Please, delete and move your post where it should be and take the time to read the different titles of each Forum section.

[Slobey]

do not evaluate was checked in all 4. just one of those things I guess.