I am sorry, I am a very new user of FM (a few months) and using the trial module of FM I found a problem that I do not know how to solve it.
I have a table like that:
- each record has his vendor and a purchase date (and a creation and modification date too), so it record is unique if we consider the entire line of that record (thinking about table view);
- some record has same name and vendor but different purchase date OR same name but different vendor and same or different purchase date;
- I want to reduce this record list to show only unique record list based on name and vendor and related to the last purchase date only;
- I created a field that do a calculation mixing record-name+vendor+puchase-date and I am using this result on a dropdown menu in a different table but I want to reduce this menu to unique names with only the last one (according to purchase date).
I am not on my machine right now but I can send some pictures later.