beginer help

[XBetadogX]

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.

[Kris M]

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, 2015 by Kris M

[XBetadogX]

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.

[Lee Smith]

Hi xbeta, and welcome to the FM Forums,

 I sent you a Private Topic and some informational links.

Lee