Help with a calculation

[rgnelson]

I am trying to create a job ticket solution.

I have a Job_Ticket table and I have an Archive_Manager table.

The way I have it set up is after the job is done, the user goes to the Archive Manager to close the ticket and archive the job.

In the Job_Ticket table I have:

A serial number field. (Job_Number)

I have a text field. (JT_Name)

In the Archive_Manager table I have:

A popup menu to show all jobs from (JT_Name) that inserts into a field (AM_JT_Project_Name).

A radio button field (JT_Status) where the user selects Active or Closed.

In another layout I want to have two popup menus:

1) That shows all jobs with their job number. I got this working like I want it using this claculation:

Job_Number &" - " & JT_Name

2) That shows only Active jobs:

How do I use the JT_Status field to show only Active jobs?

Is it and if statement or something else?

if (JT_Status = Active) & Job_Number &" - " & JT_Name

This is not working, could someone show me the correct calculation to do this?

Thanks for any help.

[sbg2]

If(

JT_Status = "Active";

// COMMENT: Then add the following text to the Value List

Job_Number & " - " & JT_Name)

or just...

If(JT_Status = "Active"; Job_Number & " - " & JT_Name)

[-Queue-]

JT_Status is almost always active. Oh wait...

[rgnelson]

Thanks for your reply!

I haven't gotten this YET. lol

So, I have a field JT_ID_And_Name_If_Active set as a calculation with this code in the calculation:

If(JT_Status = "Active"; Job_Number & " - " & JT_Name)

On my layout, I have the field AM_JT_Project_Name set as a popup menu.

The popup menu is set as Display Values From: JT_ID_And_Name_If_Active

What I get on my layout is <no values defined>

I'm stumped.

Thanks for any suggestions.

[-Queue-]

Items for value lists must be indexed. JT_ID_And_Name_If_Active cannot currently be indexed since it references the related Archive_Manager::JT_Status field instead of one local to the table.

Create a JT_Status field in the Job_Ticket table that is a calculation of Archive_Manager::JT_Status. Close the Define Database window, then reopen it and change JT_Status to a text field. Change JT_ID_And_Name_If_Active to reference the local field. Then change the JT_Status radio button in Archive_Manager to use the related Job_Ticket field. Update any other fields, layouts, or scripts which reference the field to use Job_Ticket::JT_Status. When you are satisfied with the results, you can then remove JT_Status from Archive_Manager.

On a side note, my ears are burning for some reason. Is someone talking about me? Okay, I'm done. I swear!

[comment]

JT_Status = "Active";

// COMMENT: Then add the following text to the Value List

With JT being so active, I don't think I need to add anything.