Say I build table Suppliers and table Products. Now each of these is a table in Excel. I have a unique Supplier_ID column in the table Suppliers. In the Products table I use this ID to reference the supplier.

Creator has a built-in ID field for each from. Since it is an auto-number field, I plan to use that to link tables in the Creator. Is there a way to import Excel tables into the Creator so that data from both tables are properly linked? I mean through built-in ID fields, not my current Supplier_ID field.