Can you have (Table 1)fields grab info from table 2 that contains records from an imported .xls file and delete those records once they are gathered WITHOUT deleting the fields in table 1.

If so how?

If not then how would I updated the imported file info without destroying the records on table 1? Can I trick it by getting the data thru some sort of relationship and calculation?

Once the records are deleted the info is deleted which means when I update the records with new info the old records will now use the new info and eliminate the point of keeping records...

Please help.

Edited March 9, 200916 yr by Guest

If I understand correct, you want to do this:

-You have table1 on filemaker with fields A and B,

-You have any other excel table with B values

-You want to import B values on existing records in Table 1

So simply use the import option. Select "Update existing (or matching if you have match field) records in found set" Do not map Field A, only B (and match field if exist).

Yes but doing so updates previous records which is what I'm trying to eliminate. I only want the updated info to be use on new records.

Most likely its me but I still dont understand why there isn't an option to commit the entry as a record without updating its fields unless done manually. Like a snapshot.