Jump to content
Sign in to follow this  

Question on Join Table, new to FM

Recommended Posts

I am new to FM but not databases.

I have 2 tables, Contacts and Consultants. The consultants is company based and the contacts are people. The contacts can be associated with as my companies as they want. When I bring up the company form, I want to see all contacts associated with that company. I have this working.

I have a 3rd table that is nothing more then the key for the company and the key for the people. I build a relationship between the tables and used that to build a portal on the form and it lists all the people associated with that company and I can update their info that is listed.

How do I go about adding a new people though, wither it is selected a person already in the database or adding a new person to the database.

I know how to do this with sql or mysql but I am new to FM. Thank you.

Share this post

Link to post
Share on other sites

Well a new contact would just be a new record in the contacts table; doesn't have to fancy. As for adding a new record in the join table, you can do it via scripting or relationships with allow creation of records on perhaps with using a drop down list of contacts. Personally, I like for this a scripted UI where a user choose a contact from perhaps a popup window with a widdled down layout of the contacts table.

Share this post

Link to post
Share on other sites

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
Sign in to follow this  

  • Who Viewed the Topic

    1 member has viewed this topic:
    Will Xu 

Important Information

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