script for buttons that are fake tabs

[agtjazz]

I am attempting to "not use tabs" for the data entry layouts and just use "fake tabs" (from the majority of advice on another topic). I am having trouble, though, with the buttons for the fake tabs. My layout is for one person and has the First & Last name on top and then come the fake tabs/buttons. The first button is Personal, 2nd is Position Info, 3rd is Appointment and so on.... each fake tab will be another layout. (attached are screen shots to further clarify)

But when I am on John Smith and on the Personal tab, when I click the 2nd tab- Position Info, it moves to another name- like Jane Doe.

What would a script look like for the buttons so that they stay on the same person- so my user thinks these are real tabs?

screenshots.zip

[Ender]

If you're going to another layout based on the same TO (table occurence) it will stay on the same record, but if you change TOs it could be a different record.

Generally, when switching among sub-tabs on a layout, the user expects to be in the same table. If the layouts are based on entirely different tables but are really meant to still be looking at the same person's data (like with a one-to-one relationship), then there may be a better structure. If the relationship between the tables is a one-to-many, then the tabs don't really make sense here either.

If you can explain you structure a little, a solution may become apparent.

[sbg2]

"What would a script look like for the buttons so that they stay on the same person- so my user thinks these are real tabs?"

Go To Layout [PositionInfo]

and they are real tabs, example attached.

MyDB.zip

[agtjazz]

Embarrassed but true, I don't know much of TO and how to use them. I thought a simple relationship from people to jobs would do the trick.... is there any tutorial for beginners about TO's... I looked in my books and can't find any reference to Table Occurences. :)

[agtjazz]

Attached is a screen shot of my relationships.... any advice you could provide is greatly appreciated!

I also posted another topic just asking for a review or advice on TO and if anyone can pick apart my relationship theory to make sure I am on the right track.. the topic is Post#203503 Seeking your advice (link) http://fmforums.com/forum/showtopic.php?tid/176247/post/203503/#203503/

[Ender]

It sounds like that Jobs table is really a Job Assignment table--the Job a particular employee happens to be performing during a given date range. So since an Employee can have many Job_Assignments, it makes more sense to me to make the Jobs layout based on the Employee (People) table, and use a portal to show those multiple Job_Assignments. If you wish to allow a detail view for Job_Assignment use another layout, either one that leaves the tab interface, or one that shows the tabs (just be sure to have any navigation scripts incorporate Go to Related Records[] script step when changing base TOs).

[agtjazz]

(just be sure to have any navigation scripts incorporate Go to Related Records[] script step when changing base TOs).

That is where I started trying... but am running into problems. Attached is a screen shot... I am trying to move from 1 fake tab to another fake tab all for the same person (but the fake tabs are buttons for other layouts) For example, find Joe Blow.... go to Personal Tab and fill out his address etc (that goes in People table)... then still under Joe Blow... go to Position Info (which really is job assignment- thank you for that) and fill out his base salary and hire date etc (which goes in the job table-related to People)... and so on and so on.

Can you help me with the script- what am I doing wrong?

screenshotsinword.zip

[sbg2]

Ok, new example attached (sign in as Admin, no password) with three tables: Personal, Position & Phone and three "fake" tabs with the same name. All three tabs go to different layouts from the SAME table... Personal.

Notice on the Personal Tab 2 Layout the fields are actually from the Position table.

on Personal Tab 3 there is a portal for phone numbers and using the "Show Related Phone #'s" button shows the related records in a new window on a layout from the Phone table.

MyDB2.zip