Path: utzoo!utgpu!watserv1!watmath!att!att!linac!pacific.mps.ohio-state.edu!zaphod.mps.ohio-state.edu!swrinde!ucsd!ames!haven!adm!lhc!nih-csl!helix.nih.gov From: pdurand@helix.nih.gov (Paul Durand) Newsgroups: comp.databases Subject: SQL programming problem for IBM's OS/2 Query Manager/Database Manager Message-ID: <678@nih-csl.nih.gov> Date: 28 Nov 90 14:58:52 GMT Sender: news@nih-csl.nih.gov Organization: National Institutes of Health, Bethesda Lines: 13 I've developed a working system in OS/2's Database Manager/Query Manager. I want to enter a chemical name on one of the Panels. When the chemical name is entered, I want the Query Manager to search another table( say the Profile table). If a match is found in the Profile table, I need to link the record found in the Profile table or file to the table where the chemical name is located and record (link) the Profile table information in the chemical table. Paul Durnad NIH 301-496-7775 fax 301-480-8056 -- Paul Durand pdurand@helix.nih.gov 301-496-7775 fax number : 301-480-8056