Jump to content

How to Master-Detail kind of layout?


Mitesh

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

Recommended Posts

I am a VB.net developer against Access and SQL Server. I am using FM 9.0 Advanced (30 day trial).

One of my friend asked me to design a small system that needs to work on both MAC and PC.

To start with Customer/Contact side, i have designed the tables and added the relations between Customer to Contact as 1 to many.

I have managed to create a layout to customer and contact on its own. Now i need that same functionality on one screen?

How do i go about adding a new customer and adding many contacts to that customer?

Any help would be highly appreciated for a newbie for FM.

Mitesh

Link to comment
Share on other sites

It's the same method. I just meant that you may prefer to create a new layout to display both Customer and contact.

Go to Layout mode. Then click on Insert>Portal.

Chose Contacts table.

Add the fields you wish to display and the number of records to display within the portal.

Make sure you have chosen "Add/Create New records on the Contact side of the relationship Contacts table.

You can now add contacts on the customer layout.

See attached file.

hth

Client_Contacts_DB.zip

Edited by Guest
Link to comment
Share on other sites

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