I know this sounds simple But..

[OzzieBruce]

Hi Guys 

I am stuck on a script trigger and I would really appreciate your help.

I splice fiber for a living and I am trying to track the cabinet as I visit them.

I have a from layer out fine with portals showing splices and notes Etc.

I would like to navigate between the records by clicking on a cabinet name laid out like a compass face with the current cabinet in the centre and other cabinets shown around the outside of it in a circle NWES but using 8 points.

I have this laid out fine with a field for each point stored on the table.

When I click on the cabinet name to the 2 position I want that cabinet to appear in the centre and the one that was in the centre moves up to the north, I have this working ok.

What I cannot do is: On click of field “2” have the form load the data. If South was showing Cab123 I want it to load the record containing field ”CAB”=123 

So I have on the table fields for each point of the compass (8) and one called CAB ( for the cabinet name)

when any one of these 8 is selected I would like it to load the data from a record by CAB field. I am sort of stuck on a GOTO command.

 

Does that make sense??

 

                     1

          8                  5

       3       Current        4

            7                6

                     2

 

Thank you very much for any help

Bruce

 

[Agnes Riley]

Why don't you explain in layman's terms what you're trying to achieve?

 

By the way if you're doing something visual like this you might want to use drag and drop with container fields. It's pretty cool.

[Fitch]

...On click of field “2” have the form load the data. If South was showing Cab123 I want it to load the record containing field ”CAB”=123

​Not sure of your structure, but for example:

Set Variable[ $cab ; cabID ]
Enter Find Mode
Set Field[ cabID ; $cab ]
Perform Find

 

[comment]

when any one of these 8 is selected I would like it to load the data from a record by CAB field. I am sort of stuck on a GOTO command.

​It sounds like Go to Related Record[] would be the appropriate choice - provided you have a relationship linking the cabinets in this way. The problem here is that you are describing your user interface, but you have told us practically nothing about your data structure. User interfaces are built upon data structures, not the other way round.

 

I know this sounds simple

 Actually, it doesn't sound simple at all. On the contrary, it sounds like this could be quite complicated to set up. Especially if the links are bidirectional.

[OzzieBruce]

Thank you very much for your rapid responses and I do apologise for the way in which I have tried to describe my problem.

as far as the structure goes the data for this is on the same table both the Cab_Id and the location_Id are text fields. I would like to have multiple location_Id fields so I have named them location_Id 1, locaction_id 2 etc up to 8 fields. I enter the data in to these fields myself and they are a match to the data stored in the Cab_Id field, 1 per record. So it's all on the same table.

my goal is to click on one of the location_Id fields and have the matching Cab_id record display

I have tried Go to related record, I think I used the On exit trigger but that did not work for me I may have formatted it incorrectly. 

I hope I have painted a clearer picture and I do appreciate your advice and time.

Bruce

[comment]

as far as the structure goes the data for this is on the same table both the Cab_Id and the location_Id are text fields. I would like to have multiple location_Id fields so I have named them location_Id 1, locaction_id 2 etc up to 8 fields. I enter the data in to these fields myself and they are a match to the data stored in the Cab_Id field, 1 per record. So it's all on the same table.

​I don't think that's the best structure to have, because in addition to the 8 fields, you will also need to define 8 relationships and 8 different button actions. It also makes the links unidirectional - i.e. when you link Cabinet B to the North end of Cabinet A, it doesn't make Cabinet A linked to Cabinet B from the point-of-view of  Cabinet B.

Still, have a look at the attached demo.

 

link4.fp7

[OzzieBruce]

Comment that is spoton. Just what I am wanting to have happen. I am not sure about the relationships between the node but it gives me a really good starting point.

Thank you

Bruce.

 

[LaRetta]

Comment has provided you with the best structure so I would really switch to it or discuss with him how your structure is different.  Odds are that, if your structure is different, it is also impractical and will cause you grief down the road. :-)

[comment]

Comment has provided you with the best structure

​I haven't really. I don't know what the best structure is, because I don't know exactly what the solution tracks and why. I only know that 8 numbered fields and 8 relationships is not it.

[OzzieBruce]

It has worked very well for me, thank you. Once I have added the other fields I am tracking I will send you an invite to login.

Once again thanks for your help

Bruce

[OzzieBruce]

​I haven't really. I don't know what the best structure is, because I don't know exactly what the solution tracks and why. I only know that 8 numbered fields and 8 relationships is not it.

Thanks Comment. It is working well with the 8 points of direction. The sample you sent allowed me to understand the relationships better.

if I was to make the centre a drop down list that would load the selected record once clicked, would I need to build another realtionship like the others. All of the fields around the outside will not be editable once I have store their relationmships. They will just be navagational buttons.

thank you very much for the help so far.

Bruce

[OzzieBruce]

Comment Thank you again for your help

If you are interested please have a look at

Server = 8harran.hopto.me

your username and password = TestTest

Read only of course as I have made this public

You can see how your help has made it possible to navigate between records like using a compass, Thank you very much for that. I have another couple of questions but only if you are interested in helping some more.

Kind Regards

Bruce