By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
429,471 Members | 711 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 429,471 IT Pros & Developers. It's quick & easy.

Index

P: n/a
I have an inventory control table including the following reference fields.
May 15 '07 #1
Share this Question
Share on Google+
3 Replies


P: n/a
Sorry I sent that post before it was done

I have an inventory control table including the following reference fields.
Manu Manufacture ID
ManuPN Manufacture part number
ManuCF Manufacture configuration.

For older part numbers these fields are NULL. I want to add a combined index
on these 3 fields so that they are unique if not NULL. will setting the
ignore NULL flag do this?

"paii, Ron" <pa**@packairinc.comwrote in message
news:0P******************************@athenet.net. ..
I have an inventory control table including the following reference
fields.
>

May 15 '07 #2

P: n/a
paii, Ron wrote:
Sorry I sent that post before it was done

I have an inventory control table including the following reference fields.
Manu Manufacture ID
ManuPN Manufacture part number
ManuCF Manufacture configuration.

For older part numbers these fields are NULL. I want to add a combined index
on these 3 fields so that they are unique if not NULL. will setting the
ignore NULL flag do this?

Not an answer to your question, bu can you just do a one time update
statement to set the ManuPN to <oldor something?

--
Tim http://www.ucs.mun.ca/~tmarshal/
^o<
/#) "Burp-beep, burp-beep, burp-beep?" - Quaker Jake
/^^ "Be Careful, Big Bird!" - Ditto "TIM-MAY!!" - Me
May 15 '07 #3

P: n/a

"Tim Marshall" <TI****@PurplePandaChasers.Moertheriumwrote in message
news:f2**********@coranto.ucs.mun.ca...
paii, Ron wrote:
Sorry I sent that post before it was done

I have an inventory control table including the following reference
fields.
Manu Manufacture ID
ManuPN Manufacture part number
ManuCF Manufacture configuration.

For older part numbers these fields are NULL. I want to add a combined
index
on these 3 fields so that they are unique if not NULL. will setting the
ignore NULL flag do this?


Not an answer to your question, bu can you just do a one time update
statement to set the ManuPN to <oldor something?

--
Tim http://www.ucs.mun.ca/~tmarshal/
^o<
/#) "Burp-beep, burp-beep, burp-beep?" - Quaker Jake
/^^ "Be Careful, Big Bird!" - Ditto "TIM-MAY!!" - Me
I don't want to set the old part's ManuPN to a default other then NULL. If
it is NULL I want the index to ignore the record. I want to stop users from
entering a non NULL manufacture's part number that duplicates an existing
part.
May 15 '07 #4

This discussion thread is closed

Replies have been disabled for this discussion.