Cannot Filter On Primary Key

Savatage · 2006-10-27

Something strange has happened & I'm wondering if anyone has experienced this.

For some reason I can no longer filter on Cust#, Item# or Vend#.

I can filter on anything else ...city, st , zip , etc...

i'm talking about F7 filter here.

Yes I deleted the zup and nothing changed.

I can filter on order & po #'s too

It may have nothing to do with the primary key - but I didn't know how else to explain it.

nunomaia · 2006-10-27

Normally a form Card after get each record reset's the PK filter.

SETRANGE("No.");

It's this?

Savatage · 2006-10-27

If I open the item card (for example)

click on the No. field
then click the field filter icon
hit ok

it should say "Filter" on the bottom saying that their is a filter pesent.
but when I hit Ok the filter doesn't work.

If I clicked on No. 2 and try to filter just this item there is no problem, or if I use the description or any other field - it just seems not to work on the "No." field. thsi is also happening on the vendor card, customer card & item card.

that I have found.

nunomaia · 2006-10-28

Yes, it's a problem or feature:-). Every time you navigate a record in a form card the PK filter its reset.

Normally "No." filter is the primary key, so it's reset. View the form card C/AL
If you open the code of the form, it's there.

nelson · 2006-10-30

Use the Customer List, Vendor List, etc. forms to apply filters on these table's primary key field.
It's always been like this, but you just probably never noticed it before, Harry.

Cannot Filter On Primary Key

Comments

Categories