I have a project of a data base that requires the Footer to chnge to Diffeent panels like a baner ad does on a web brouser.

How can I do This in my data Base?

Setup a series of global container fields, or a global repeating container field. You will need enough to contain all the possible variations that you want to display. Into each field put a different variation.

Put a calculated container field in the area where you want the thing to change. The field should be a calculation of result container.

It would be defined as a CASE statement like:

CASE (

criteria = "1", gContainer1,

criteria = "2", gContainer2,

criteria = "2", gContainer3,

and so on...

)

You can also use a relationship to another file, if you want to store th various footer options as actual records, rather than field, but this is a bit more complex to setup. Although this will make long term maintenance easier.

CaptKurt,

Thank you for the kind details... I'v simply not able to master it yet the way you explained.

I'v decided to have it look for the container field information form another file.

So in the main file with the Footer with a container field.

I also have a look up file called containerData.

Now how do I have the info from the containerData go to the

Footer container field and show all the records one by one from the containerData. And can I have it pause for a few sec. and move on to the next LOOP till the main file is closed.

Thank you for your direction

[ November 09, 2001: Message edited by: LynfordD ]

[ November 09, 2001: Message edited by: LynfordD ]

[ November 10, 2001: Message edited by: LynfordD ]