I have a situation whereby I need 3 linked forms. This has arisen because of this scenario:
A vehicle will be sent out to several locations, and at each location it will pick up several items. So I need to record:
date of collection
So there will be one or many Collections per Load, and one or many Collection Items per Collection.
What is the best way to enter and display these details? Normally I would contemplate using subforms, but with 3 levels this could become unwieldy. Does anybody have ideas or examples of a good solution please