Jump to content

beginer help


XBetadogX

This topic is 3111 days old. Please don't post here. Open a new topic instead.

Recommended Posts

  • 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.

Link to comment
Share on other sites

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 by Kris M
Link to comment
Share on other sites

This topic is 3111 days old. Please don't post here. Open a new topic instead.

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.