How does one go about adding/linking the manufacturer field from the Price Book table into the Quote and Service Order tables, or any other table for that matter?
Announcement
Collapse
No announcement yet.
Add Manufacturer to Quote and Service Order Tables
Collapse
X
-
Originally posted by Bob Williams View PostI don't understand why you would want to link these tables. A custom report can easily print this information on the quote or Service Order.
Comment
-
Sorry, should have enclosed that info. Look in tblPriceBook for the column Manufacturer. From the quote or SO item, link to tblPriceBook using the ItemID a the key.Last edited by Bob Williams; 08-16-2014, 09:12 PM.
Comment
-
Originally posted by Bob Williams View PostSorry, should have enclosed that info. Look in tblPriceBook for the column Manufacturer. From the quote or SO item, link to tblPriceBook using the ItemID a the key.
If it's not to much to ask for could you provide more details on how to do this? I get to the point of linking in the Database Expert within Visual Studio, but cannot seem to get any output from the fields I am attempting to link. It won't let me link by key, it says I must do by name.
I added the desired column to the desired table and linked, which was unsuccessful. I feel like I am really close, but I cannot seem to figure it out.
Comment
Comment