Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations IamaSherpa on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

@DbColumn/@Dblookup - using formulas to limit results

Status
Not open for further replies.

mastro78

Programmer
Apr 10, 2007
70
US
I currently have a view I want to feed a report doc from. The 5th column in the view is Type, I want to limit the @Dbcolumn to show only a specific Type (value = Type 1)so that my @Dblookup on another field pulls in only the relevant data for the field Models.

Not sure if I'm making any sense here. Thanks in advance for any help.
 
Typically, you'd need a view listing your data with the most complete key possible. If the Type is part of what you need to lookup, then you'll a view that sorts the data with the Type and whatever other key value you need.

Pascal.


I've got nothing to hide, and I'd very much like to keep that away from prying eyes.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top