LookUp Tables

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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 & "')
 
Back
Top