RE: LookUp Tables
- From: "Ofer" <Ofer@xxxxxxxxxxxxxxxxxxxxxxxxx>
- Date: Wed, 8 Jun 2005 16:23:01 -0700
The dlookup can return only one value, to return more then one value it is
better to use Open recordset then running few dlookup, that way you access
the record only once and get all the values
But in the dlookup you can perform filter on more then one field
dlookup("FieldName","TableName", "FieldNumber = 1 And FieldText = 'aa')
You can also filter on parameters
dlookup("FieldName","TableName", "FieldNumber = " & Param1 & " And FieldText
= '" & Param2 & "')
"olorin53" wrote:
> Being new to this, I would like to know if LookUp Tables can have more than
> just two fields. (i.e. pkProductType, and Product).
> The reason being is that ALL products have a unique part number.
> I am reluctant to use the part number as the Primary Key even though it is
> unique to each product. I also wish to build tables for components (that go
> into the products) that also have unique part numbers.
> Would I be able to have THREE fields in the LookUp Tables?
> That is "pkProductType", "ProductPartNumber", and "Product".
> I have read enough on various forums etc to know that Look Up Fields should
> be avoided like the plague.
> Any help would be appreciated
.
- References:
- LookUp Tables
- From: olorin53
- LookUp Tables
- Prev by Date: Re: E-mailing data and receiving it back in
- Next by Date: RE: select random records
- Previous by thread: LookUp Tables
- Index(es):
Relevant Pages
|
