How do I create related tables from a newly imported flat XL sheet?
Hi, I'm new to FileMaker but have experience with MS Access. I have imported a single flat XL sheet with a list of transactions on it. I would like to create a new table of vendors and relate it to the vendors in my transactions table. I imagine this is a well trodden path. I cannot seem to find the appropriate technique though. Could someone point me in the right direction please?
In simple english I want to create a vendor table of the unique vendors occurring in the transaction table. Give them each a vendor ID and replace the vendor with vendor ID in the transaction table. At the same time there should be a one to many relationship tying the tables. I can then add more vendor data to the vendor table.