I am building a calendar database. I have one database that is the calendar itself, and each day has a repeating portal of events that occur on that day. I have made that repeating portals buttons, and I want to be able to hit the button which will take me to that particular event, which is a record on a different database. I don't know how to go from one databse to another, select that particular record that is represented by the button/repeating portal, and have only that event show. I by no means an expert , so please explain in detail. Thank you.

quote:

---

Originally posted by [email protected]:

I am building a calendar database. I have one database that is the calendar itself, and each day has a repeating portal of events that occur on that day. I have made that repeating portals buttons, and I want to be able to hit the button which will take me to that particular event, which is a record on a different database. I don't know how to go from one databse to another, select that particular record that is represented by the button/repeating portal, and have only that event show. I by no means an expert , so please explain in detail. Thank you.

---

The concept is easy, the reality is more complicated, but simpler once broken into the parts of the concept.

2 steps are involved.

First use the Go To Related Record [Event by DayID, Show Only Related Records]. This will create a found set in your Event database of only the events for that calendar day.

Second use the Perform Script [External, Event] to run a script in your Event database, which will take you to a layout for displaying the event chosen.

Setup these two scripts as seperate items and you should not have any problems.

------------------

=-=-=-=-=-=-=-=-=-=-=-=-=

Kurt Knippel

Consultant

Database Resources

mailto:[email protected]

http://www.database-resources.com

=-=-=-=-=-=-=-=-=-=-=-=-=