Forum Discussion
How to Join Two Columns Into One Based on Data Values
I cannot click on that option; is there a step prior to that?
Watch this video.
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?
I also went to each table and moved the column of Location to the beginning to see if that would make the selection easier but it didn't.