Hi All,
I'm working on a model-driven app that uses two tables from the data verse. The app uses a form that's generated using my project table. What I want to do is be able to include columns from my second table which is called Details in this form while still just using the project table. The project table has columns such as % completed, Stage ID, Start date, Project Status, etc. The Details table has columns such as Project manager, project location, project type, etc. The primary columns for both these tables are Name (project name or details name). When I perform a 1:N relationship from details to project the name is the only column that is sharable. In other words, I can only look up the Details name in the project table. When I do that, I want to be able to get several other columns in the project table/project form via the details table. Is there a way that I can create a relationship between the two so that I can have Project type, project manager, location, etc. show on the project table/form without just creating those columns there?

Report
All responses (
Answers (