Reminders from numerous tables

[STEVO75]

I have a number of tables, each holding various important dates that we need to be reminded of. How do I have all these dates displayed together in a suitable reminder table format? Please point in the direction of what I need to read up on to solve this problem.

[Søren Dyhr]

Tricky question, since all ought to belong to the same table ... If any usual database tasks needs to be performed. But you can't really get an answer on a question with so little to go on. To get a proper answer, must no doubt be regarding context and purpose!

You could in theory use one table as joiner of them all linking relationally on the date provided the date field is the same. But how would you then deal with several appointments at certain dates, they would then flow into a new dimension.

No you need to import each of the tables into one single, and continue using only that table. After each import will a found set exist and here should an empty field be given a category which should be a pseudonym of the original tables name, this is conveniently done via:

http://www.filemaker.com/help/Script-Steps52.html

--sd

[David Jondreau]

It depends and it's impossible to say without more information. What is your solution trying to accomplish in the real world? And how is it doing that? What are the tables that have dates, how do they relate to one another, and how do you want the reminders to be displayed?