I am trying to automate a sales plan that has a plan with lots for sale. Once a lot is sold a red dot is added to the plan, if a lot is on hold a green dot is added.
Currently this step is done in Illustrator, saved as PDF and then I append the pricelist from Filemaker as PDF. Lots of steps and to much room for errors.
I have created the dots with conditional formatting, that works fine, but I am trying to work out the best way on getting these all on the plan.
The challenge is, how do I add the dots from multiple records on one layout in various spots. See plan attached.
I also want to make it as easy as possible as I will have to re-do this when new lots go on the market.
My current database shows one record per lot as the base.
I have gone through various scenarios with a sub-table and a record per lot, a sub-table with a field per lot, but haven't really found anything that works.
I guess I could do a relationship per lot, but this is getting a bit of a nightmare for new lots in the future. We are not just talking about 50 but 500+ lots.
Ideally I only have to place a field per lot once on the plan and the rest is calculated based on the main table.
Any ideas on how I could solve this would be greatly appreciated.