Viewing Portals in Tab Controls...

[Protour Travel]

First of all, I hope everyone here along with your families, friends and loved ones have a very safe and prosperous new year.

 

Now, I'm not really sure where this belongs topic wise. It could be either layouts, portals, tab controls or scripting.

 

I have a layout that contains tab controls, outside the tab controls are fields that pertain to all the info that belongs within the tabs. Static info if you will.

 

In the attached example, the static field is the TourID field.

 

Contained within the tab is the Tour Expense information. It contains two portals, one for cash received and the other for cash spent. No problem so far.

 

The problem I am having is this; whenever I start a new expense period, I cannot seem to get the cash received and the cash spent portals to show the latest information. They always show the original data.

 

Also, using the new period script as it is written, the db automatically adds a new (empty) field to the cash given portal.

 

This has to be a simple step that I am overlooking but hours have turned into days and I need to move along.

 

In other words... "Somebody please help me..."

 

Regards and once again, Happy New Year,

Charlie

TabControlPlayground2.zip

[bruceR]

"Contained within the tab is the Tour Expense information. It contains two portals, one for cash received and the other for cash spent. No problem so far."

 

No, that is not what it contains.

 

It contains a portal for expense periods; and a portal for expenses.

 

There is no cash received portal. The purpose of your relationships is unclear.

[bruceR]

Since the purpose of your data relationships is unclear; and you want help; you might try to explain as best you can what you are trying to do and what purpose the relationships are intended to serve. What are expense periods? What is the connection between expense periods and expenses and advances and tours?

[Protour Travel]

Thank you for your interest BruceR. I spent yesterday looking this thing over some more. I like to figure things out on my own if somehow possible.

 

First off, you were right, The relationships didn't make sense. The portal to the left contained records for 'expense periods' when it should have contained the records for 'cash float. That has been corrected in the attachment.

 

Now to explain the concept a little. The file is being written for tour bus drivers. Please remember that in professional touring, nothing is sacred. Meaning there are no standard timelines.

 

A driver is given a tour and a bus to drive on that tour. Let's say the tour is 10 weeks long. The tour manager will give the driver some cash, let's say $2,000 to cover fuel and other bus expenses during the tour.

The tour manager determines how often the expense reports are to be handed in and tallied. Some will go weekly while others will tell the driver to come back for more after the $2K is spent. For our example, lets use weekly reports (expense period).

 

There would also be other tabs that would contain portals containing items from Itinerary Dates, EZ-Pass Charges and Payroll. Each of these would only house one portal.

 

The fields placed outside the tab control are fields which would stay the same for the entire tour. Artist Name, Tour Name, Start Date, etc.

 

The fields placed inside the tab control are fields from the 'expense period' table. Of course, these change from week-to-week in our scenario. The portals would be for expenses and cash received which change on a daily basis.

 

What I am trying to accomplish here is that when the driver opens the file and starts selecting tabs, the latest period is what he will see in each tab. That is not what I am getting now, Now it shows the initial period's records.

 

Now bear in mind that the expenses periods are most likely the only information that is restarted weekly. The EZ-Pass charges could go weekly or whatever period the driver and tour manager agree on. Payroll could be weekly, bi-weekly or the length of the tour.

 

Also, I have placed two green arrows on the tab. often times a driver needs to look back on past records for information or to print lost reports.

 

I hope this explains things better and I truly hope you can help.

 

Also, other than neatness and compactness, the reason I am wanting to use tab controls is because when you go layout-to-layout it's too easy to forget to enter data that could be crucial in your reporting.

 

Thank you very much...

TabControlPlayground2.zip

[bruceR]

If there are multiple expense periods then:

 

You need a portal to display them.

 

You need to SELECT (filter by) the expense period you wish to work with.

[bruceR]

For instance...

TabControlPlayground2.fmp12.zip

[Protour Travel]

Thank you, Sir.