Problem with lookups
I am using FM Pro 10 to create a solution to fill out government shipping forms that I can save and print. I have a file (the Data File) which contains the data (like address,product descriptions, etc) to complete the form with each Data File record containing a unique serial number. I want to be able to use this Data File serial number to import the data into the file containing the shipping form fields (Form File) and save the data based on when each record is created regardless of the subsequent changes made in the Data File. The main table in the Form File contains a unique serial number for each form created and I am entering the Data File serial number into a related table in a portal (4 lines in the portal if it matters) within the Form File to import the Data File information into.
The problem is that when I create a new record in the Form File and I use a matching serial number from the Data File to import the data into the portal line, the data is reimported into all the existing records with portal lines that match this serial number . Is there a way to set it up so the import from the Data File only imports data into the current record of the Form File? Is there a better way to set up the solution then using FM import capability?