Linking multiple fields in one table to one field only in another

[Adrian C]

I am building a database which will store client details for counselling.
Each client is given a sheet than contains a large list of the sorts of
problems they are facing from which they can choose 3 that are the best
match. In the database this static data is stored in one table ('presenting
issues'), and is linked one-many to each of the three fields in the client
table (being choices 1, 2 & 3), however this multiple link completely stops
the input form from working, it comes up blank unless I remove the
'presenting issues' tables from the query that drives the form.

I am beginning to think I may have to store the 'presenting issues' data in
3 seperate (but obviously identical) tables.

Anyone have any ideas?

 

[Douglas J. Steele]

It sounds as though you're trying to store all three choices in the same
row. That's generally not a good idea. Instead, you need a separate table
that you can link to your existing "presenting issues" table, with one row
for each of the choices.