Adding a combo field to an existing database
Posted on 2011-09-26
I recently downloaded a Charitable Contributions database (not web version) which seems ideal to support a small charity. All has gone well and I now want to add in a new combo box to a form so that I can record whether a contributor has allowed their donation to receive 'Gift Aid' or not. I ideally want to add a combo box with "Yes, No, or Don't Know" as the only options although even a Yes/No box would do.
The problem I am finding is that this information needs to be linked to one or more tables (one would do). For example my 'Contributors Table'. This appears to be linked to a Query called 'Contributors Extended'. Two forms hold individual details: 'Contributor Details' and a list of all contributors, 'Contributor List subform'.
So my problem is where to start? What I have tried so far is to create a new lookup field called 'GiftAid' in 'Contributors Table' and alter the query 'Contributors Extended' so that it displays this field. I then create a combo box using the wizard in both forms but when I return to Form View the data is never displayed correctly or no data displays or I get a lengthy drop down box with either no data or data from the FirstnameLastname field. Please help! Many thanks.