I am trying to create a table that includes information from Item Ledger Entry, Item, Produce Type, and Produce Size. I can link to Item from Item Ledger Entry by joining the tables on Item No. I can link to Produce Type from Item by joining the tables on Produce Type Code. I have not figured out how to link to Produce Size from Item. I should be able to join the tables on Produce Size Code but I get an error when I try to use a second InclusiveLink back to Item. The error states that the link must be to the previous link (which is Produce Type) or to the table in the NL function (which is Item Ledger Entry).
How do I link two different tables to the Item table in a NL Table function over Item Ledger Entry?
Date
Votes
3 comments
-
Jet Reports Historic Posts Hi,
The Table Builder message is correct. You can only have multiple branching links from the main table. You can't branch off from a table in the middle. There were technical reasons for this restriction, which involved some ambiguous situations where Jet would not be able to determine what the user really intended. However, you can link to the Item table multiple times from the main table, which sounds like it would work for you, since you just want to go through the Item table to a different table. Does that work for you?
Regards,
Hughes -
Jet Reports Historic Posts Thanks for your reply.
I tried what you suggested but I'm still getting an error. This time it is telling me that my LinkField statements are ambiguous. I have the following links, in this order:
∞||"Item","No.","=Item No.","InclusiveLink=","∞||""Produce Type"",""Code"",""=Produce Type Code"","""","""","""","""","""","""","""","""","""","""","""","""","""","""","""","""","""",""""","","","","","","","","","","","","","","","",""
∞||"Item","No.","=Item No.","InclusiveLink=","∞||""Produce Size"",""Code"",""=Produce Size Code"","""","""","""","""","""","""","""","""","""","""","""","""","""","""","""","""","""",""""","","","","","","","","","","","","","","","",""
You can see that I am linking from the main table to the Item table twice, with inclusive links to Produce Type and Produce Size tables. I then have LinkField statements to retrieve the values I need from each of those tables.
Any suggestions?
Richard -
Jet Reports Historic Posts I figured it out.
You can link through a table multiple times as long as you are not trying to retrieve any fields from that link-through table. Once I removed the fields that I was trying to retrieve from Item, it worked without a problem.
Thanks again for pointing me in the right direction.
Richard
Please sign in to leave a comment.