 sandyc
|
 |
| Joined: 18 Oct 2007 |
| Total Posts: 32 |
| |
|
Closets/ Boutiques Needs List
Posted: 16 Mar 2010 09:16 AM |
| Is there any way to run a report to pull the items entered in the Closets/ Boutiques form that was in need, but have since been closed? I am trying to reduce the list of items in the drop down box on the Closet/Boutiques form. I have went through and deleted all items we want off the list with the exception of one. It tells me that "the DELETE statement conflicted with the REFERENCE condtraint "FK_tblClosetNeeds_ClosetList"". The only solution I can come up with is the item is closed. I've ran both "Closet/Boutiques Statistics" by the measure "item description" and "Closets and Boutiques Needs Report" and the item does not show on either. Can you help me? |
God Bless,
Sandy <><
|
|
 |
|
|
Re: Closets/ Boutiques Needs List
Posted: 18 Mar 2010 02:47 PM |
Hi Sandy,
My suggestion would be been to run Closet/Boutique Stat for multiple years, to find the item. If this doesn't work let me know.
Blessings,
Ashleigh |
|
|
|
|
sandyc
|
|
| Joined: 18 Oct 2007 |
| Total Posts: 32 |
| |
|
Re: Closets/ Boutiques Needs List
Posted: 19 Mar 2010 07:23 AM |
I had to do that to change the other items on the list. The problem is, we decided to only track certain items specifically. To simplify things, we are now entering the lesser given items in one category - "other". My belief is that I may have changed the item to "other" when a client picked it up, but missed it on the needs list. Does this make sense? Thanks, Ashleigh. Do you have any other suggestions?
-Sandy |
God Bless,
Sandy <><
|
|
|
|
|
Re: Closets/ Boutiques Needs List
Posted: 19 Mar 2010 10:04 AM |
Sandy,
Please contact your Account Manager, 469-293-3079, so that we can better assist you. We look forward to hearing from you.
Blessings,
Ashleigh |
|
|
|
|