Re: I know this sounds like a real newbie question but...

In article <DFMHAL.L4A@cix.compulink.co.uk>, Stuart Hemming <shemminga@cix.compulink.co.uk> wrote: |I have a 2 tables; shipdoc and addresses. Now for reasons that are far to |boring to go into now I have to save the address data for each shipping |document on the shipping document (very non-normalised I know). However, |I do want to look up the address in the addresses table when I'm creating |the shipdoc record. | |The key to my addresses table is addrcode, addritem. I'm getting the |customer code entered and then the address item. However, I can't use |both values for my lookup <blah> joining <more blah>. The result is that |I'm getting the first record in the table when the lookup is actioned. Have you read up on the COMPOSITES statement (Instructions section) ? -- Alan Denney aland@informix.com "Yes, Evil comes in many forms, whether it be a man-eating cow or Joseph Stalin, but you can't let the package hide the pudding! Evil is just plain BAD! You don't cotton to it. You gotta smack it in the nose with the rolled-up newspaper of goodness! Bad dog! B-A-D dog!" -- The Tick