Your value list is based on values from the products table, but you are in the transactions table when you are triggering the value list in the dropdown. What is the relationship between the transactions table and the products table - it is probably the relationship that is causing the "filtering". You may need to set up another Table Occurrence (TO) from the transactions TO to a new products (TO) that can see all the products - and base your value list on looking across the relationship to the new TO.
Hope this helps. Chris
I wonder if that ID field might be of type number instead of text. If your ID's are going to be a mix of numbers and letters, it will need to be of type text or the index from which these values are drawn to produce the value list will only list data based on the numeric digits and that sounds like what you are describing here.
Thank you Mr. Cullen
Yes Product table is parent and Transaction is child and both have relationship through ID. So I created another table name "Product Name List" and only inserted 2 fields, ID and Name. Both are text field but have unique data. The list showing in drop down or popup is complete now. Before it was not accepting any keyboard entry. I mean I wanted to type 5 so list should automatically be scrolled to entries starting from 5 of 50. It also behaving like that now.
Thank you again for help.
For Mr. philmod
ID field was first Number datatype then change to Text but there was no change. I was surprise that in MS Access it was very normal but why no in FM. Now I remember that we were taking that popup list either creating a new query for that purpose or from a separate table only created for taking the list.