Hi all,
I have a little question and I know it’s going to be a very simple one for some of you guys……but my little brain can’t work it out![]()
(I apologise, this question may have been asked and answered previously)
I have a Table of Materials that I need users to enter details in for when there is a new Material (there are about 20 fields).
So I have created a Form linked to this Table with all the fields, so that they can just go to last record, add a new record and enter in all the details
I have read quite a few responses from people saying not to put Drop Down Lists (Lookup Lists) in a table (Using the Lookup Wizard) and have said it is better to do it on the Form rather than in the table..
How do I do a lookup list through the Form for a field from the table so that the user can select an option? (I only need it on a couple of fields) As there are some fields that I need them to select from a lookup list rather than manually typing it in (obviously to eliminate typo errors)
If I do the lookup list through the table field properties it works, but what’s the best way….and how??
I’m not very good with all this Code/SQL/Macro stuff, so in easiest terms in the Design View would be a great help
Appreciate any help!!
Thanks in advance guys![]()