Jump to content

Getting relationship information in a portal


Ray H
 Share

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

Recommended Posts

I have been trying to setup a relationship between three tables, customer, cars and model.

I have setup the relationship between the customer and cars and setup a portal but I am now trying to setup a relationship between cars and models.

The end result would give me a portal on a layout called customer where I could select a car make in a portal and then select the model that relates to the car make.

I have been struggling with this for a couple of weeks now and just do not know where I am going wrong.

Any help/advice would be most welcome

car.zip

Link to comment
Share on other sites

First, make a relationship from cars::make to model::make.

Now set the value list for Models to "Use values from field" -- specify the field as model from the above relationship, and "Include only related values starting from" -- specify cars, again from the above relationship.

One other point, in your attached file you noted that you'd like to be able to add a model on the fly if needed. You can type in any text you wish using the setup described, but it won't actually create a record in the model table. Your best bet there is probably to script a button to pop up a new window where you could add a model record.

Link to comment
Share on other sites

This topic is 5737 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
 Share

×
×
  • Create New...

Important Information

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