1 Reply Latest reply on Jan 2, 2012 11:05 AM by philmodjunk

    One Table imported. now the second ??



      One Table imported. now the second ??


      I am new with FM pro adv 11 /OSwin7.

      I managed to do a  "Open File (Excel) and got every field on the layout.

      In this Table "Company" I have also all the different CompanyIDs  in LayOut.

      In a second Excel file (for Products) to be imported,  I have also CompanyIDs and ProductNames


      I need to make a kind of listbox, giving the products supplied by Company XXX, whioch pops up

      For maybe  5  or 40 products whatever the link/relation is.

      What to do....i, file, open, second file....... OR.. Import Records...?? and CompanyID= CompanyID.. ?

      I have "Missing Manual/FMPro Bible", but cannot find between so many pages.

      Thanks for any help.


        • 1. Re: One Table imported. now the second ??

          For starters, you use Import Records. You can specify "new table" as the target table to create a brand new table if you have not already defined the table to receive your data from the excelfile.

          Your "kind of list box" sounds like a portal from your companies to your products table. This will require a valid relationship between the two tables.