dlookup function

[FT OFFICE]

Good day.

I was told by someone the dlookup function was I wanted for this but I am
not quite sure how to implement it.

I have a table called Sales. I have a table called Packages.

In the Packages table I have the fields: package, fullAmt, halfAmt and
quarAmt. These are the deposits that are taken for each package sold.

What I want is on my SalesOrder (I'm not sure if this is to be done on the
table or form) is to have the amounts I see in the 'Amt' field in my
SalesOrder restricted to what applies to each package.

So if I choose a GK package, I will only see 698, 349 and 174. If I choose
AR as the package type, I will only see 498, 249 and 124.

I'm not sure if this is clear enough for someone to help me, I sure hope so.

Thanks in advance.

-Rob

 

[Carlos Alberto-Brasil]

try the link below for a nice description of DLookup
with actual examples. Hope this helps. There is a 2000 version as well.
http://support.microsoft.com/default.aspx?scid=kb;en-us;136122

Carlos Alberto-Brasil