Look Up Field Question
Hey Everyone, Forgive the question if it is an easy one, I'm struggling on understanding this issue and could use some help! I'm wanting to pull some data (currency) from one table to display into ...
Forum Discussion
Thanks as always Blake!
------------------------------
Alex Bennett
------------------------------
------------------------------
Alex Bennett
------------------------------
Can I ask what you might recommend for the Field type for the field that will combine the two? They are currency, but I was thinking it would need to be a formula field.
------------------------------
Alex Bennett
------------------------------
------------------------------
Alex Bennett
------------------------------
- MarkShnier__You
Qrew Legend
yes it will be a formula numeric field with the formula
[field 1] + [field 2]
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------- Thats what I was thinking. Just wanted to make sure! Thanks Mark!
------------------------------
Alex Bennett
------------------------------- Hey guys,
So I got the look up fields working, however, in the app that I'm trying to create, there are 7 different departments to display different currencies each by phase(4 phases). Right now each department just has the same numbers in each field (which are the correct totals, but only for one of the departments). I'm thinking I need to create different look up fields be each currency I need to display. And if that department isn't involved in that job, and doesn't have any totals, its left blank. My confusion is if I just create all these different look up fields, how will QB know what I'm referencing so say one department shows the correct total, and another isn't involved and doesn't display anything?
------------------------------
Alex Bennett
------------------------------
