LynfordD Posted November 6, 2001 Share Posted November 6, 2001 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? Link to comment Share on other sites More sharing options...
Kurt Knippel Posted November 6, 2001 Share Posted November 6, 2001 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. Link to comment Share on other sites More sharing options...
LynfordD Posted November 9, 2001 Author Share Posted November 9, 2001 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 ] Link to comment Share on other sites More sharing options...
Recommended Posts
This topic is 8365 days old. Please don't post here. Open a new topic instead.
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now