Hello everyone
Hopefully this is a straight forward question! I am very out of practice (not used Access for over 20 years!) so I am extremly rusty!
I have successfully created a table and a linked form. It works very nicely - I can now very easily see our database of potential customers. I have decided that I want to add a field showing whether they are retailer, maintenance or construction. I have added a lookup field to the table - it has a drop down box which allows me to choose either 1, 2 or all of those options depending on the context of the business.
I have added it to my form (well I thought I had!) and it doesn't work. Instead of showing me which industry for each record, each form just shows all 3 industries. On the Design View for the form, the box where the answer is supposed to show says 'unbound'. But I thought I had bound it to the table because I chose which field from the table I wanted it to link to.
Does anyone know what I am talking about (!) and can help?! I have googled it and looked at videos but I find the guides not exactly what I want and they are difficult to understand too :/
Any help would be very much appreciated.
Wendy
EDIT: I have just deleted the field from the form and just added an existing field, linking it to the table. It now works better but is only showing the first industry in the drop down, so for example, all first 5 records just say retailer when in fact a couple of them in the table are retailer AND maintenance