August 28, 201510 yr Newbies I'm very new to file maker so this may seem easy to some. I have built a database of a personal info and company info for that person. I want to be able to create just new company info for that record using same personal info then cycling through the different company info for that person. can anyone help or point me in the correct direction. there is no info in the file so can happily share if u need further details.
August 28, 201510 yr Best advice at this point is to work through the FM training series. http://www.filemaker.com/learning/training/fts.html You could add fields to the persons table that identify the company. This would accomplish first normal form but not support any higher normal forms. https://en.wikipedia.org/wiki/Database_normalization If a person can have one and only one company then you need to join the companies and persons tables in a one to many relationship. If a person can have many companies then you need a join table to solve the many to many relationship between the two entities. All depends on the requirements of the system. Edited August 28, 201510 yr by Kris M
August 28, 201510 yr Author Newbies Thanks Kris time to start reading. I see it was moved to relationships area so I'm assuming that is a great place to start.
August 28, 201510 yr Hi xbeta, and welcome to the FM Forums, I sent you a Private Topic and some informational links. Lee
Create an account or sign in to comment