Varying Field Input Based on Information Availability
I'm going to explain what I would like to do and then I will ask my question....
1. Pull information from a different database into specific fields in a test report (also a filemaker database)
2. When the correlating field has data in it, in the database I am pulling from, I want it to copy into the test report
3.If the correlating field has no data in it then I want to delete thar field in the test report and move the adjacent field over to fill its place (so that there are no akward spaces on my test report)
The last step is what I am having issues with. How can I get this done?