I have a flat Filemaker database that I would like ti split to make it more flexible.
The database stores names and what sports they like. (just a silly example).
As it is now, in the flat design, I have hardcoded 10 sports. All of them has one field in the flat datebase. Yes or no field
So when I recreate the database with more than 1 table I get.
In this case, I will not see the sports that they dont like. I will just se the lines that I have created in the sports table by relation to Customers tbl.
Has anyone an idea of how to get a fixed amount of lines in the portal on creation of a post in custumors tbl. And also of course how to add the necesary lines in Sports tbl for the existing ones.
I would like to solve this to be able to add any sport wihount loosing the visibility of sports to choose from. Thjs is the tricky part.
No problems on creation. I could add a button that imports the lines from someware else. But how do I fill up the missing sports for existing once?
I hope my explonation was good enoughf