Index and query relation?

dvh

Registered User.
Local time
Today, 16:58
Joined
Aug 23, 2006
Messages
28
Hi guys

thank you in advance for any idea/info!!

i have 2 tables, P.O and Invoice. In PO tbl i have an Invoice field with Index set to Yes (No duplicate)
On a form based on PO table, I couldnt enter a new record due to this so i set the Index back to NO
Now..I have a combo bound to PO table with a query taking a list serial number from another table. I want to filter away whatever serial numbers from this list that have been added to PO so i write this SQL
"SELECT DISTINCTROW tblComputer_Cabinet.[CC_Serial #]
FROM tblComputer_Cabinet, tblPO
WHERE (((tblComputer_Cabinet.[CC_Serial #])<>[tblPO].[CC_Serial #]))
ORDER BY tblComputer_Cabinet.[CC_Serial #];"
which worked fine before i removed the index

Why was it?
 
Typically, if you have a form with index set to Yes (No Dup), you might be creating the record too early. How were you assigning the number that was the basis of your index? Autonumber or computed or what?
 
I dont know if i understand you right but the field IO in PO table has "Number" as its data type.
How can the index interfere in this case i wonder?
 

Users who are viewing this thread

Back
Top Bottom