Hi there. I'm a truck driver and I'm using FDB Free to keep track of my loads. I have one table for customers (which can be shippers or consignees), one table for each load, and one table for additional stops.
Additional stops means any stop where I load or unload freight, except the first our last such stop. For example, I pick up a load in Belvidere, IL, and take it to Cheyenne, WY, where they take the entire trailer load of freight. This load has no additional stops. Then I drive to Greely, CO where I pick up another load. I take that load to Detroit, MI where they take some of the freight. Then I drive to Delaware, OH where they take the rest of the freight. This load has one additional stop.
The way I have the relations set up now, I can only see one additional stop when I look at the load in the form I created for the loads table. I can also see the pickup and final delivery locations, but not the location of the additional stop that is shown.
Each load has a unique ID number, and the load table includes an integer field indicating how many additional stops there are. How do I set up the form to show all of the additional stops, and hide that section entirely if there aren't any additional stops?