Conditional Value list/ table relationship problem EMERGENCY

[carolynhaywood]

I have an emergency situation! I need to migrate the old database to the new database on Saturday and I can't until I can solve this problem. Any help is greatly appreciated!

Table jobinformation

Table Billabletime

- Table Billabletimeselected is an occurance of table Billable time

Table Codes

- Table CodeType is an occurance of table Codes

- Table CodeType is an occurance of Table Codes

- Table CodeCode is an occurance of Table Codes

Table occurance billabletimeselected has a field job id and a field billableid

Table Job Information has a field job id and a global field billableIDselected.

The relationship between the two is jobID =JobID AND billableid = billableIDselected

Like this:

JobInformation::JobID = BillabletimeSelected::JobID

AND

Jobinformation::billableIdSelected = BillabletimeSelected::billableID

CODE OCCURANCE RELATIONSHIPS:

CodeType::type =CodeSection::Type

CodeSection::section=CodeCode::section

I have 4 value lists based on the relationships of these tables.

1. Type = Codetype::type; all values

2 Section = CodeSection::section; values from Codetype

3 Code = CodeCode:code; values from CodeSection

4 Description = CodeCode::descripton; values from CodeSection

I have two tabs with 2 portals on a layout based on table job information

tab 1 = billabletime portal

tab 2 = billabletimeselected portal

each record is connected by a button with the script: "'set field jobinformation::billableidselected;billabletime::billableid"

Portal billabletimeselected has 4 fields based on the value lists above: Type, Section, Code, Description.

Each field as the appropriate value list assigned to it.

When a new record is created the field type works - a pop up menu appears with two values to choose from.

When you click on section, code, and description, it says "no values defined"

that is my problem.

In the value lists, if I select use all values, all values are shown so I know that the field and the value list is working. It's only when the tables are related that the problem occurs.

[carolynhaywood]

I think I may have solved my problem.

My value lists should look like this:

Type -

CodeType::type

use all values

Section -

CodeType::Section

use values from CodeType

Code

CodeSection::Code

Use values from CodeSection

Can anyone verify that this correct? I am at work and not able to access my database to see if this is correct.

thanks