How do I link 2 tables together when there is no data yet to link them

Ask for Help
1

I am trying to create a journal wherein the page will be display Question as Text and there will be Answer as Text Entry. List of questions will be in Question table, while the answer to the question will be in Answer table

So when I land on a page, source will be Question. I created Cards to be Question (Text) and Answer (Text Entry) but how do I link that the Answer will be saved in the Answer table?

3

I would suggest adding a RowID column to your Questions table, and use this as a QuestionID.
Then add a QuestionID column to your Answers table, and when an answer is submitted, write the associated QuestionID into this column.
Then you can use those two columns to build a relation between the two tables.

2 Likes