So you only want to import ONE of each Developer into your Developers table In your Developers table, go to field definitions and the validations tab. Set it to 'Valid data in this field ALWAYS' , uncheck 'Allow User Override' and then in Requirements, check 'Unique.'
Then import your flat file into Developers and specify Add New Records only. This will only allow ONE of each unique Developer into the Developers table. Both your Products table and your Developers table should have a unique, FM-generted auto-enter serial number for their table, called ProductID and DeveloperID respectively so create them now if they don't exist. Then relate as:
Products::Developer = Developers::Developer
Then read this post on how to now switch the relationship to being based upon proper keys:
Once you have the tables related using your new keys, you can delete the Developer field out of Products. To view the Developer name in Products, simply place the related Developer::DeveloperName field on your Products layout.
I have been my present solution for the last six months, there was about 300 records for products related to unique developers from the developers table (related to products with a foreign key). Both tables have unique serialized primary keys.
I have been asked to import a much larger older flat file with over 53,000 product records into this file, so I flushed the 300 records I had (redundant) but not the records for developers. Is it better to flush out the developer records too?
Are you saying I should create a developers field in the products table and do the same with the developers table with unique value for each developer. Relate these two developer fields and then later delete the field from products. Please bear with me if I am not following this correctly. Thanks