A recordset-related question
I have a database set up with three tables, foreign keys etc set up correctly. I need to set up a form which will upload a review of an organisation to one of these tables, but because I want to have reviews published for each organisation on a separate page, I need to have the person posting the review select the organisation from a drop-down menu. This menu will be populated from a different table.
This is probably an obvious newbie question, but I've not worked with foreign keys before and can't get my head round how it will work. I don't have a problem with the upload form part, that's something I've done before, but I've never tried to pull in data from another table and link it in this way - is it going to work if I set up a recordset from my "organisations" table to dynamically generate the list of organisations, then set up the form that uploads the new data to the "reviews" table?
I can't decide whether it's more simple than I think it is, or more complex, but I'm sure I'm not the first person to try and do something like this, so if anyone's had experience of this and can point me in the right direction, I'd really appreciate it. Thanks in advance.
