AnsweredAssumed Answered

Relationship and FM script

Question asked by restos on May 5, 2009
Latest reply on May 5, 2009 by restos


Relationship and FM script


Hi there,


First excuse my english because it is not my natural language. 


I have a problem with one FM database.  This is the scenario:


- 2 Tables with one field with a relation. One numeric field is the same in two tables.


- In the table 1 we have some text fields, date and the numeric field with the realtion.


- In the table 2 we have the numeric field and we want to show the date of the last register of the table 1.


- First we type in the numeric field in table 2 the number and we need any way to show the last date of the table 1.


How can I do it?


I´ve tried add the table1(date) to the layout on table 2 but only shows one date and not the last date. 


Any help?



Also we have more than two tables and we need to do the same thing with the other tables.