Relationship and FM script
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.
Also we have more than two tables and we need to do the same thing with the other tables.