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

Stuart writes:- > ...I've always used 4GL for everything and I've never had to try and do > anything clever in PERFORM. Now I *have* to use it 8-( Well, never mind! > > Imagine the situation... > > 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. > > What am I missing? I know that it can be done; I have access to a system I think you should look at the composites statement in the instructions section of the form. There is an example of doing this in the stores demo. It is used to get stock information. > where it is being done (sadly, no access to the source). In the app I've > seen when you enter the customer code the main address comes up and > changes if an address item other than 1 is entered. This is my ideal. > > I hope someone out there can help me. > > TIA > > ------------------------------------------------------------------- > These are *my* opinions. Please don't make the mistake of believing > anybody else is stupid enough to think like this! > ------------------------------------------------------------------- > Stuart Hemming | shemminga@cix.compulink.co.uk > The Data Base | Tel: + 44 (0) 115 925 0005 > Nottingham UK | Fax: + 44 (0) 115 925 0951 > ------------------------------------------------------------------- Malcolm Weallans Online Database Consultancy Phone 0628-72154 Fax 0628-37463 CIX - onlinedbc