Jump to content
Claris Engage 2025 - March 25-26 Austin Texas ×
The Claris Museum: The Vault of FileMaker Antiquities at Claris Engage 2025! ×

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

Recommended Posts

Posted

I have created my business contact database with around 200 fields. All of these fields are in one database table. My different tabs are for example Director 1, Director 2, Co sec, Subscriber, etc.

How do I create more tables then link these all up so I can seperate my tab list a lot more easily. So say that my Director 1 tab fields of say 20 boxes are in one database table.

Hope someone can help.

Thanks

Martin

Posted

Create a unique auto-generated contactID in the main contact table then, you can create a related table with a contactID field too (foreign key). Allow the relationship to Allow creation of records in the related tables. So when you enter values in the related fields, it should create the related record automatically.

I recommend you read some articles / whitepapers that are on the FileMaker website (you can find some on data normalization and the tutorial files as well. There is also a "Data Modeling/Relational Design" webinar you might want to take a look at.

http://www.filemaker.com/downloads/

Good luck.

This topic is 6614 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.