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"...
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!