Is it possible to use 2 calls to the same table for different results. For instance, in one table, we have two contact numbers. I'd like to tie that number for each of the instances to the Contact table, which would then give potentially two contacts. I've built it as it should work, but it issues an error. Is there a way to name the attached tables, so that they can be used with out ambiguity?
Date
Votes
2 comments
-
Jack Ries This would not work using table builder. However, this would work if you were using multiple NL functions. If there are at most two contacts per table (Is this for customers, or vendors perhaps?), then you could do an NL("First") to return one contact and then in another cell, do an NL("Last") to return the other (if it exists).
-
Tanner Selinger Yes, I know how to do that. I like the table feature because of the way it solidly delivers the data. My hope is that I could make a call to the Contact table two different times in one table query. Thanks anyway.
Please sign in to leave a comment.