I have a little more information.
So it looks like I might need something like a SQL-Join?
I need to call up in my laytex (pdf) the model number of our vendor...
which looks like SQL calls "Partnumber" I am thinking I might need some
help, as one of our programmers suggested I might need to use a
SQL-JOIN. PartNumber is located in the PartsVendor Table, from the
field: Parts_ID which is a foreign key used by the PartsTable. .... Can
I use in Laytex PartsVender_PartsID or something like that to call up my
model number?
I am not sure how to code this.
Jeff
On 4/20/2011 11:19 AM, Jeff Kaminsky wrote:
I am taking the basic pdf picking list template, and I want to add
model numbers (vendor models numbers)
I need to know what SQL references that model number with such as
(modelno)
The place I need to info from is found
Goods & Services
Reports
Parts
(pick any part number and look at it)
Halfway on the page, there is MAKE and MODEL
I realize there maybe more than one make and model for each part, and
I don't know how to compensate for that, but the vast majority of our
parts have a single make and model number. So I need to know what the
model number is referred to by.
So my picking list will ultimately consist of..
Picking List
Sales Order Number
Required by Date
Bill to: Ship to:
Number.... Description..... (and then I want to add) Model ..... Qty....
Sadly I am an accountant, and not a programmer, so I know how to find
it on my own.
Thanks in advance,
Jeff
--
Jeff Kaminsky
Sr. Accountant
IX Systems
408-943-4100 ext 122
_______________________________________________
SQL-Ledger mailing list
[email protected]
http://lists.ledger123.com/mailman/listinfo/sql-ledger
