Field Type: Related Sheet

jnompleggi

There should be a way to link data from Sheet A to Sheet B. For Example, we have a sheet A to track all of our vendor demographics.

We then have sheet B for tracking invoices. On that sheet we have a column for Vendor. We have to maintain our Vendor Sheet and then update the Vendor column on the AP sheet so the drop down for Vendor includes the new option. We should just be able to have a column data type to reference another sheet. Then we only have to maintain our vendor list in one place.

I know this can be accomplished with Data Shuttle, but that's not a scalable option. Look at most of your competitors for examples of how it can be done.