Dropdowns and Databases

Hey there people,
so we are creating a website for our project in university.
We are currently having some mayor/ minor troubles and would be happy if someone could help us:

Basic Infos: 3 Databases
Questions
Answers
Country-List

Databases are filled with information submitted by users.
Information should later be shown on “the most important page”.

  1. We created a form to submit details to the answer database. In this form there are two dropdown menus: One for countries and the other one for already submitted informations (called ‘questions’) into another database.

We want people to be able to choose the ‘Question’ they want to answer from a drop down menu as well as the country they are from. We already figured out how to create that dropdown from a database menu. The problem is that when one clicks submit the chosen item from the drop down doesn’t go into the database.

  • Is there a problem because of these ‘crossreferences’ between these two databases?

I hope I made myself clear and some could help us.
Best wishes
André
P.s. more questions to come :smiley:

Are all form fields bound to ‘answers’ dataset?

Hey Eli,
i solved my problem by simply just configuring the country list not by a dataset but by sinmple dropdown inputs. Now all form fields go into the dataset. But thank you anzway!