Some record not showing on query.something wrong?

[romanticode]

I have make relational table on query, but some record not sohowing on query, although i have the record on table.

for example, i can't see the record with code :
131401.007
541000.00*

is the anything wrong?

thanks

 

[ajetrumpet]

Yep, the record marked with the asterik is not in the table.

 

[Rabbie]

I have make relational table on query, but some record not sohowing on query, although i have the record on table.

for example, i can't see the record with code :
131401.007
541000.00*

is the anything wrong?

thanks

record 131401.007 is showing in query when I run it.

No records like 541000.00* could be found in table STOK Plk so because records have to be in all 6 tables to show in query results the query is working correctly.

 

[romanticode]

No records like 541000.00* could be found in table STOK Plk so because records have to be in all 6 tables to show in query results the query is working correctly.

I see that some records that's found on one, and not on all of the 4 STOK table, can be showed. foun record show the amount (xx), not foun record show 0.

I just want to campare the 4 STOK table, so i need to show all in he 4 STOK table, using SKU table as identification of Item. How can i do that?

thanks