Completing a look up

[cergos]

Scenario as follows - In FM file, select an item category from popup list. A sub set of items appears in 2nd popup box (eg select Soda in list 1 - sublist of sodas appears in list 2 eg Coke, Pepsi, 7up etc)

Now the next step is to have 4 fields - Supplier, Contact, OfficeTel, MobileTel - so that when you select (eg) Coke - the suppliers details appear in their correct fields.

Can someone guide me through this

PS ... many thanks to Jason ... thus far.

cheers

[CobaltSky]

I'm afraid this one's a duplicate (or should that be triplicate) post.

Check the other version of this message at:

http://www.fmforums.com/threads/showflat.php?Cat=&Board=UBB18&Number=53546&Forum=All_Forums&Words=&Match=Entire%20Phrase&Searchpage=0&Limit=100&Old=2days&Main=53546&Search=true#Post53546

for a detailed answer.