Site code is a seperate field, but not currently indexed. Would it help to index it?
>>I have an application that was single site and had unique inventory numbers as the primary key. The application has to become multi site and the primary key will be ALLTRIM(inventory number) + sitecode (site code is 1 character). For many forms I will need to be able to retieve inventory records
ONLY for that site. What is the best way to do this?
>
>Hmmm, maybe something like this:
>
>SELECT * from mytable where RIGHT(my_primary_key, 1) = "7"
>
>
>The better way might be to make the site key the separate indexed field.