Hello, So i am working on an app where on the welcome screen you have to set a traject number and choose to create a new project or work with an existing project. I have 2 tables, "dbo.Project" and "dbo.Traject". The traject database has a column projectID which contains the ID of the project database. so if you choose a new project the following happens.
But imagine there is already an existing project created just like this. I want to have the projectID, in the traject table, set to the project's id that already exists. Can you guys help me? Thanks in advance!
Edit: you can choose an existing project with a dropdown.