insert category Id into Items table

Can some please help me how to insert the ID from Category and Department 
tables into the Items table. I have the does some one have the correct SQL 
for this
Thank you
jm
0
JM (81)
8/30/2006 4:58:01 PM
pos 14173 articles. 0 followers. Follow

1 Replies
881 Views

Similar Articles

[PageSpeed] 28

can u explain it further?

"jm" wrote:

> Can some please help me how to insert the ID from Category and Department 
> tables into the Items table. I have the does some one have the correct SQL 
> for this
> Thank you
> jm
0
Nashat (16)
9/11/2006 3:27:02 PM
Reply:

Similar Artilces:

How do I set the way email addresses display in my send items?
When I send email to a group, I only want the name of the person to display on the email. This was automatic in earlier versions of Outlook. In 2003 both the contact's name and email address is displayed when I send. How do I set a preference to correct this? Your post is unclear. You have asked two unrelated questions. First you are asking how to display only one persons name when sending to multiple recipients. No version of Outlook ever did this, despite what you may think you remember. To do that requires a mail merge to electronic mail, not sending to a "group." Ne...

Deleting a Windows Live ID from the drop-down list
On the sign-in page, the drop-down combo lists all the Windows Live ID's available. Is there a way to remove any one of the items in the list? Found the solution :-) Click the down arrow next where it says "sign in as", then click "forget me". "grovelli" wrote: > On the sign-in page, the drop-down combo lists all the Windows Live ID's > available. Is there a way to remove any one of the items in the list? "grovelli" <grovelli@discussions.microsoft.com> wrote in message news:05823788-4A4B-4ACC-9033-4C8802C7AF43@m...

How do I insert Roman Numerals?
New to Word 2007 would someone please explain to me how to insert Roman Numerlas in my document? "ckj" <ckj@discussions.microsoft.com> wrote in message news:6CF0C580-BA6E-463D-B4FD-E6A6FDD9E814@microsoft.com... > New to Word 2007 would someone please explain to me how to insert Roman > Numerlas in my document? Just type them... I II III IV V VI VII VIII IX X XI etc etc. Type a number e.g. 21, select it and run the following macro Dim oRng As Range Set oRng = Selection.Range oRng.Fields.Add oRng, 34, oRng.Text & " \*Roman"...

Exchange 2003 SP2/Sender ID
I have a bunch of domains configured in the recipients policy and they all work fine except for one. When people try to e-mail it they get "550 5.7.1 Sender ID (PRA) Not Permitted". The SPF DNS records for that domain are configured the same way as for all the other domains. What am I missing? Sample headers: "This is an automatically generated Delivery Status Notification Delivery to the following recipient failed permanently: recipient@domain.com Technical details of permanent failure: PERM_FAILURE: SMTP Error (state 12): 550 5.7.1 Sender ID (PRA) Not Permitted ...

Add territory & category to leads form
Hi there I would like to add the "territory" & "category" fields to my Leads form retaining the picklist values I have set for these fields in Accounts. On conversation of lead to Account, I would like these fields to map to the corresponding territory & category Account fields. One further question I am not sure you can answer as it is third party related - will these customised fields be viewable remotely on Blackberry - I am using Tendigits / CRM3 Many thanks James ...

MNY2006 Small Business: Categories
Is there a way to enter in a beginning balance for expense categories? In microsoft.public.money, Cindy Nelson wrote: >Is there a way to enter in a beginning balance for expense categories? I am not sure what you are asking, but you can use an expense category for a deposit to an account. Accept the warning. I just started using Money 2006. I was using Peachtree last year. My ending balances from Peachtree are going to be my beginning balances for some categories like Depreciation - Vehicle. Do I set this up as an account, like my checking? Thanks. "Cal Learner-- MVP" wro...

Not plot a data series in a chart but still display in data table
MS Excel 2007 I've somehow managed to display only two data series on my line chart. They still display in the data table. How did this happen? More importantly, how do I reverse it. I don't want to recreate chart. I see the data series not plotted on chart in the Chart Elements and when I select the series, the source data is highlighted; it's in the data table. How do I make it visible? Thanks! Miriam HAve you perhaps simply formatted the data series as "no line, no marker"? If so, you can format series, add some color. -- Best Regards, Lu...

Insert trigger
Looking for some advice on SQL 2005. I have a table that will usually be populated by an SSIS package. I want to set the "loaddate" column to the current time after a record is inserted. Should i do this via trigger or should i just build a step in the SSIS package to update the column after the file loads? If trigger is the way to go, what is the syntax to create the after insert trigger? Thanks in advance. You can create a default constraint on the table set to CURRENT_TIMESTAMP. That will handle the automatic date assignment without any need for coding. -...

should be able to view more attributes on the item list
I would like to be able to view more options on the item list like the other attributes on the general tab. I need to be able to distinguish between color and size etc. and when going to item lookup, it is hard for me to do that when just looking at the description or lookup #. It would be nice to be able to view any of the colums on the detailed item list and choose the look of it like on the reports (the part where we can pick what fields show up on the report) or just an arrow and the ability to sort the way the columns show up in the box. Right now if I am not sure if I am choosing ...

record cash receipt by invoice line item
Great Plains should allow the option to enter one cash receipt per invoice line item. ---------------- This post is a suggestion for Microsoft, and Microsoft responds to the suggestions with the most votes. To vote for this suggestion, click the "I Agree" button in the message pane. If you do not see the button, follow this link to open the suggestion in the Microsoft Web-based Newsreader and then click "I Agree" in the message pane. http://www.microsoft.com/Businesssolutions/Community/NewsGroups/dgbrowser/en-us/default.mspx?mid=397cb5cd-706b-4edf-b717-1f0f64a1c01e&a...

Creating more 48 Accounts Categories
Dear Users, May I know if it's possible to create more than the standard 48 Accounts Categories in the category Setup? Will the categories be used in the Financial Statements when I print the standard P&L report? Thanks Andrew yes to both questions HS "illion" <anonymous@discussions.microsoft.com> wrote in message news:130101c46f0a$b3b24f60$a301280a@phx.gbl... > Dear Users, > > May I know if it's possible to create more than the > standard 48 Accounts Categories in the category Setup? > Will the categories be used in the Financial Statements > ...

inserting hrs and minutes
I have a cell in my time card that displays total weekly time -ex- "40:15" is there a way to make it more like this...40hrs,15mins -- Message posted from http://www.ExcelForum.com Use a custom format hh"hrs",mm"mins" -- Regards, Peo Sjoblom "-Brian-H- >" <<Brian-H-.110wgs@excelforum-nospam.com> wrote in message news:Brian-H-.110wgs@excelforum-nospam.com... > I have a cell in my time card that displays total weekly time -ex- > "40:15" is there a way to make it more like this...40hrs,15mins ? > > > ...

Insert | File > Attachmnet-Button Drop Down ;What is the difference between Insert and Insert As Attachmnet
re: "Outlook2003, File-Insert-Options" On making new-email with Attachment-File(s), ** File Menu | Insert | File >>> (Brows and select File to insert ) then we can see the button "Insert", and write side Drop Down Arrow lower-right side of Dialog Box; If it clicked, we can see three options as follows: ** Insert Insert as text Insert as Attachment I can not recognize/understand the difference between "Insert" and "Insert as Attachment" *** What is the difference between Insert and Insert As Attachment ? I would appreciate y...

Updating a table
I have query that relates to a table and i want to be able to automatically insert a comment into a range. I.E Table column is called Report name. I want to open the query and have it ask me the name of the report. When i enter it i want it to auutomatically enter the name in the column so that all the other information that i add afterweards is associated with the report. I then want this info to save when i exit. Can anybody help? ...

insert an interactive excel file into word web page
I'm trying to insert a excel file into a word document with text, and then save it was as a web page, but I want to keep the excel part interactive. Any ideas? ...

Inactive Items
We have several dormant items which we dont want to delete since we might activate those in the future. These items by the way have historical data but no current inventory, allocated, on order, returned or in use quantities. Kindly advise what is the best way to prevent the users from accidentally adding transactions to these items. Thank you. Change the Item Type in Cards>> Inventory>> Item to "Discontinued", this will warn the user that this item is discontinued on Receiving and will not allow the Sales. Mak sure not to select "Remove Discont...

record cash receipt by line item
Great Plains should give an option to record cash receipt per line item on an invoice. ---------------- This post is a suggestion for Microsoft, and Microsoft responds to the suggestions with the most votes. To vote for this suggestion, click the "I Agree" button in the message pane. If you do not see the button, follow this link to open the suggestion in the Microsoft Web-based Newsreader and then click "I Agree" in the message pane. http://www.microsoft.com/Businesssolutions/Community/NewsGroups/dgbrowser/en-us/default.mspx?mid=29790378-1040-4f47-90f1-65567d808f0c&...

Inserting Hyperlinks in a Protected Sheet
Hi I run Excel 2000 and I have a protected worksheet that I share wit users in my organisation. I want to allow the insertion of a hyperlin to a specific file type within a specified directory on our server. 3 Questions: 1.Protection on disables the insert hyperlink command. Can this b overcome with worksheet activate code? 2.Can I limit the types of files (preferably by requiring the file t meet a mask format eg "z-*.xls")? 3.Can I limit the directory that can be linked, by referring to pathname stored in a cell on the active sheet? Would appreciate your suggestions. Thanks S...

Creating tables
I have a client trying to create a report. He has tables within the report that show costs on a bi-yearly basis. He doesn't want bi-yearly. He wants the table set up in bi-weekly tables, but the drop down menu doesn't allow it. He can do days, months, and years, but not weeks. That will not show up in the drop down menu. It is strange! How can this issue be corrected? ...

Money Plus & Windows Live ID Sign-In Problem
Hello, For the past week or two, I am unable to sign in to my Money Plus account with my Windows Live ID. On intial attempt when opening the file, the application states "Money could not verify your sign-in information...". I'm using the latest verion number 17.0.120.1415. My account is setup to retrieve infromation from MSN Money Central because this was the only way to get Etrade updates. I tried to create a brand new Money file to see if my file was somehow corruptedd an I received the same error. I am able to sign in to many other MS services using the same Wind...

MS outlook 2003 try to send email says "Item missing"
I am trying to use outlook for the first time, but won't send or recieve--says item missing. Thanks! Chrisie <Chrisie@discussions.microsoft.com> wrote: > I am trying to use outlook for the first time, but won't send or > recieve--says item missing. Did you create a mail profile? Did you define a mail account? Have you created your data store? Tell us exactly what you've done so far and we'll tell you if anything's missing. -- Brian Tillman Yes, I have done all those things... Thanks for your help! "Brian Tillman" wrote: > Chrisie <...

Insert with a where condition
Hi, sql 2005 I have an insert statement that is ignoring the where condition. That is, I want to insert records when they do not already exist in the destination table. INSERT INTO dbo.tblmnuGroupPerm ( gId ,mtfID ,... ) SELECT @gID ,mtfID ,... FROM dbo.locmnuTabFunction AS ltf WHERE ltf.mtfID NOT IN ( SELECT gp.mtfID FROM dbo.tblmnuGroupPerm AS gp WHERE gp.gId=@gID AND gp.Deleted=0 ) Any ideas or recommendations appreciated :-) Many thanks, Jonathan It's OK... <oops "redFace">I did not correctly se...

Event Viewr: ID 52
I'm gettint the following error in event viewer: Event Type: Warning Event Source: Disk Event Category: None Event ID: 52 Date: 5/31/2010 Time: 4:45:41 PM User: N/A Computer: COMPUTER1 Description: The driver has detected that device \Device\Harddisk0\DR0 has predicted that it will fail. Immediately back up your data and replace your hard disk drive. A failure may be imminent. Other info: OS Name Microsoft Windows XP Professional Version 5.1.2600 Service Pack 3 Build 2600 OS Manufacturer Microsoft Corporation System Manufacturer MSI System Model MS-7309 System...

Taxes on SO should auto apply Taxes to an Item
Regarding RMS V 1.3 - I think that SO Manager should hold the Tax Info on a per location basis, then have the option to select the default tax on a per location basis. This would lend for creating an item in HQ Manager and assigning it as 'Taxable' or 'Non Taxable', but not having to assign one locations Items Tax. Then when the item is issued to locations via a 'Worksheet Style 250: Update Inventory - Items', it will just straight assign the appropriate default Sales Tax, thereby elevating the need to issue a 'Worksheet Style 320: Adjust Item Sales Tax' ...

Insert
I want to overtype in a Publisher text box. I find I can only insert. The "insert" key doesn't do anything. ...