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.
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.