Forum Discussion
Solved
How to Join Two Columns Into One Based on Data Values
I have a dilemma in my Tables and Columns. We manage preventative work in an application and I'm working with that data. I notice that when the preventative work is tied to an "Asset", the "Location"...
Thanks; saw the video but cannot select both columns, they are in different tables and when I try and use Shift and/or Control with a Click Select, one of the selections defaults to the first column of the last table, so it merges a different column and not the one I want. Is there another way to select them?
What it the relationship between both tables (Asset and Preventative Maintenance)
I think you can use Related Function.
Asset Num is in common for both, one Asset Num to many on the Preventative Maintenance Table.
How can I use the Related Function?
MarcelBeug and Vvelarde
Thank you to both! I used the Related option to work this one, but the Merge Column will come in handy on other things I'm working on. Thanks again!