RedRock

Hi Folks, I hope somebody may be able to offer some suggestions on a weird problem I am having. I am doing an import of a 5000 row excel spreadsheet into FM8 and are importing based on matching rows based on one key field. The import seems to work fine, but the resulting data in FM shows some weird symbols in the first field of the row on records that aren't supposed to have anything in that field, but these records do match the key field. Symbols such as #N/A, and random characters seem to appear. I am doing other imports and they work fine. It only seems to be when I am doing an import that uses the matching function. I have even tried clearing these fields in the spreadsheet prior to import, and changing character sets etc. Any suggestions would be much appreciated. Thanks Paul

Thanks guys, option D worked a treat, much appreciated. Regards Paul

Hi Folks, I hope somebody can offer some assistance here. I have 2 tables, related by product code. I start with exactly the same records in each table, then some get deleted in the second table. I need to find out which records were deleted. The main table is static historical data, whereas the second table is a working table. All I need to do is by using the data in the main table, and a find or relationship, determine which records are in the main table and not in the second table. Probably sounds easy, but I just can't figure out how to do it. Any suggestions would be greatly appreciated. Thanks Paul