Calculated Field>Uncalulated Field Relation. Should work?

[Tissot]

Hey guys!

Need you help on this one. I came to a problem with this Relation.

In the g.Bit there is a "1" and the PostedSwitch goes to "1" when its posted, the ActivQuoteSwitch is "1" when the Quote is activated.

The relation should display all Quotes outstanding (not gone out). FM just gives me a blank Portal. Can some one point me in the right direction?

Thanks so much.

Regards

Edited June 30, 2008 by Guest

[mr_vodka]

Are both the q fields indexed? Also is your portal and fields in the portal referecing the correct table occurrence?

[Tissot]

No only one is. Thats the problem, it wont let me index it because it gets it from another table.

What is the best aproach to get the Activ and Posted Quotes show in a portal?

Cheers

Edited June 30, 2008 by Guest

[mr_vodka]

You can not use an unidexed field as a key on the child side of a relationship. You will need to tackle it from the parent side.

What is it referencing?

[Tissot]

Its referencing a Quote ID which is in the Projects Table. The switch is 1 when ID = Project::ActiveQuoteID So there can only be one ative quote per Project.

Cheers

Edited June 30, 2008 by Guest

[mr_vodka]

Well it seems like you are storing the Active Quote in the Project table. So if you create a new table occurrence of Project to your GUI 2 using the 'X' operator for a cartesian join, you can use either a value list and a calc with ValueListItems(fileName; "YourValueList") or List ( Project 2::ActiveQuoteID ), as an additional key in your GUI.

[Tissot]

Gotscha! Selfjoin!!!

I was trying to relate to a third table.

Still a minor issue:

When I try to relate the both of them the protal is still blank.

[color:red]p.Bit ≠ q.PostedSwitch AND

p.ActivQuote = q.ID

p.... = Project Table

q.... = Quote Table

Whats going wrong?

Thanks for your help so far.

Edited June 30, 2008 by Guest

[mr_vodka]

I guess I dont know why you switched to a self join unless your GUI TO was from it to begin with. p.Bit should be global I would think and p.ActivQuote shoule be the calc that I was referring to earlier...

At this point I am stabbing in the dark.

[Tissot]

Sorry for missleading you, I dont mean Selfjoin!!

Projects Table > Quotes Table

p.Bit ≠ q.PostedSwitch AND

p.ActivQuote = q.ID

I used a stored Calc. Maybe thats the problem?

Since I'm running it on a FM Server would I need to add the 1 in the global every time?

Thanks

[mr_vodka]

either that or you can use a calc field with the value 1. The other field should be unstored automatically if you are using any one of the calcs I provided as the data comes from a related table.

[Tissot]

Got it!!!

Thanks very much.

Cheers