Hi folks,I’m trying to use the @DbLookup in such a way as I dont have to specify the key, fieldname or keywords. I have this implemented in a combo box were i want the user to pick a “view” first before they can go any further. I just want them to go as far as the view for now…this is the error i am gettin “server error: entry not found in index” Any help would be appreciated.
Subject: @DbLookup
Mickey,
Why would you want to use @DbLookup and not specify kay, fieldname or keywords. That is the sole purpose of @dblookup!!
You need to build a field on your form that has all the views in the database and use that as your combo box formula selection
@DbLookup and @DbColumn are only used when you know the view
HTH
Mike
Subject: RE: @DbLookup
hi Mike,Because there is so many views in the database, i wanted the user to choose the view(in this case the group!)first, then the user would choose the group(which would be the key!)then I wanted to use the @DbLookup again to find the fieldname(which contains the members of the group)…just a process of narrowing down the search bit by bit!!! Maybe this is not possible to do…??? Slightly confused here…
Subject: RE: @DbLookup
Mickey,
You can pass a variable as the name of the view, so you could do something like:
@DbLookup(“”:“”;“”:“”;myview;mykey;[FailSilent])
If you had a field called myView which allowed the selection of the relevant views. You could do the same with the key, but the key would have to be relevant to the selected view. You need to either use @Error, or [FailSilent] to catch the ‘Entry not found in Index error’. PS You’ll need to use view aliases if you’re using them.
If you’re not passing a key, you should be using @dbColumn.
Hope this helps
Phil.