My question is: how can I change the view of a column to text when it is referring to another list that is also referring to another list?
Is there a general problem when referring to a list that is from another list in Access?
Here is the problem and how I come to it:
I have three tables.
The first table (2 columns) has a list which defines types of methods I use.
1 HS-GM-MS
2 NMR
3 ICP-MS
The second table (three columns) has a Look Up List list which reads these method types and from a drop down box I can select to make this table, where I also in a third column add the date I performed the method:
1 HS-GM-MS date1
2 HS-GM-MS date2
3 ICP-MS date1
Table that is made from another list: png:
The problem arises in the third table (three columns), what I want to see is a list of items and select from a drop down list the method by date that was performed like this:
1 item1 HS-GM-MS date1
2 item2 HS-GM-MS date2
3 item2 ICP-MS date1
4 item3 Hs-GC-MS date1
How I setup the dropdownlist: png:
But I actually see this:
1 item1 1
2 item2 1
3 item2 3
4 item3 1
Where it shows the index number of the method instead of the name I have given in the first table.
Like this: png:
Thanks for any hints, help or advice.
I also am lacking words to describe these problems and so any guidance to correct search words would also be a help.