Finding records. Broken???
Posted on 2006-05-13
I have two tables.
One is the main table and the other is a relation ship to another table containing systems.
There are two fields of interest in the systems table "System" and "Type"
There is a value list built from all the Systems where you can selects one of those systems from the systems field in the main table.
You could also bypass the list and type in your own if it isn't in the list.
I put the "Type" field in the main layout for autopopulation and there are four types.. lets say A,B,C,and D (but if its a custom entry, nothing with be displayed)
The thing thats causing a big problem and I dont know if it just started or not. But I cant pull a find of all As,Bs, and Ds but Cs will work.
All the types show up at least 10 times in the main table so the entrys are there. But why isn't it finding anything?!? This is gonna really screw me up. =(