turning a calculation into a table

[LLX]

In my DB i have a calculation field that i feel could be streamlined into a seperate table and reference instead of a complex calculation but i'm not sure how and thought someone might have ideas.

Case (Type = "Basic Subscriber" and Country = "USA"; "USA 1 Year - 6 Issue Term" ;Type = "Basic Subscriber" and Country = "Canada"; "CAN 1 Year - 6 Issue Term" ;Type = "Ezine Subscriber" and Country = "USA"; "Ezine 1 Year - 6 Issue Term" ; Type = "Digital Subscriber" and Country = "USA"; "Digital 1 Year - 6 Issue Term" ;Type = "Single Ezine Issue" and Country = "USA"; "Online Single Issue" ; Type = "Single Digital Issue" and Country = "USA"; "Online Single Issue" ; Type = "Single Issue" and Country = "USA"; "Single Issue" ;Type = "Free Subscription" and Country = "USA"; "Complementary Subcription" ;Type = "Basic Subscriber" and Country = "United Kingdom"; "UK 1 Year - 6 Issue Term" ; "..." )

[Raybaudi]

Yes, you can start with add a separate table with 4 fields:

Id related

Type

Country

Description

[LLX]

the tricky part is that i used Type and Contry to generate the long description currently so Type and Country are in the first Table (records) why wound i need them in what is basicly a table to make getinng the long description simplier need to reference 2 fields

(ie isn't matching Records::type, Records::Country to Description::Type, Description::country a obtuse design?)

[Raybaudi]

These are some records from the new table:

Id--- Type------------- Country---- Description

1---- Basic Subcriber--- USA------- USA 1 Year - 6 Issue Term

2---- Basic Subcriber--- Canada---- CAN 1 Year - 6 Issue Term

3---- Ezine Subscriber-- USA------- Ezine 1 Year - 6 Issue Term

and so on.

[LLX]

guess i see what your going for now, thanks.