Jump to content

related fields


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

Recommended Posts

I want to make a contacts table with First Name, Last Name, Title. These fields are repetitive and my form should display a table showing all with a scroll bar beside it. Can anyone help me please?

Jess.

ps. I heard that related fields are not good. Why? Is there limitations? Alternatives?

Link to comment
Share on other sites

I guess I wasn't clear.

I have a DB with a list of Companies, and for each record, I need another list of Individual Contacts (ie. FirstName, LastName etc) to be displayed in EACH Companies form.

What are the ways to do this? (Records within a record)

How do I actually implement something with related fields/files. (portals? )

(I meant "i heard repeating fields was bad")

THanks a lot.

Jessica

Link to comment
Share on other sites

quote:

Originally posted by Ndesaint:

I got the same problem...

Since the reference to a related file is as simple as <<Relation::Field>> how do you make FMP find more than one (and a priori unknown number of) related set of fields?

You basically just need to add the Portal object to the FMP layout. You set the Portal to the same relationship and place the related fields within the portal. This will then display the list of all the related records.

------------------

=-=-=-=-=-=-=-=-=-=-=-=-=

Kurt Knippel

Consultant

Database Resources

mailto:[email protected]

http://www.database-resources.com

=-=-=-=-=-=-=-=-=-=-=-=-=

Link to comment
Share on other sites

quote:

Originally posted by Jessica:

ps. I heard that related fields are not good. Why? Is there limitations? Alternatives?

Related files and fields are a good thing! It is the REPEATING fields that you have to watch out for.

Repeating fields are an old flat file based implementation of a relational type of data. They have been replaced by true relational functionality and were left in for backwards compatibility.

Though they still do have some use in the hands of skilled developers, I recommend that you stay away from them as they will make your life MUCH more difficult in the long run.

------------------

=-=-=-=-=-=-=-=-=-=-=-=-=

Kurt Knippel

Consultant

Database Resources

mailto:[email protected]

http://www.database-resources.com

=-=-=-=-=-=-=-=-=-=-=-=-=

Link to comment
Share on other sites

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