Jump to content

Problem with 2 overlaying portals


FUBAR
 Share

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

Recommended Posts

I'm not sure if FileMaker has the capability for this, but this is what I'm trying to do.

I have a main database with one layout which includes a text field (Equipment) and 2 portals (one directly on top of the other.) I use one portal with a relationship between the main database (using the Equipment field) and a second database (Generators). I then set the second portal to use a relationship again using the Equipment field to a third database (Golf Carts).

So for the first record I match "Generators" for the Equipment field and the correct information is displayed in the portal (14 records are displayed.)

However, for the second record I match "Golf Carts" for the Equipment field and only the first record of the third database will appear (the record that does appear is correct but I want all 14 records to be displayed)

Sorry for any confusion with my post and I thank anyone who takes the time to read this.

Link to comment
Share on other sites

No, you can't stack portals and achieve correct operation. FM wouldn't know which portal the fields were in. You shouldn't need to stack portals.

Having separate databases for each type of equipment is probably not a good structural option. The idea of databases is not to have to alter structure (add files) to add an additional type of equipment. The perceived need to stack portals seems to point to an incorrect structure.

I think what you might want is a single database storing both golf carts and generators, identifying different types of records by a field "equipment type".

-bd

Link to comment
Share on other sites

Thanks for the reply.

I do admit that it's not the best structure but I wanted to test the programs capabilities.

Also, the problem that I find with combining the two seperate equipment into one database is that there are a large amount of records (basically I have a large number of different equipment types and I was just using 2 as an example.)

The overlaying portal test was something that I tried to split the database down to speed up performance.

Thanks again

Link to comment
Share on other sites

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