- Joined
- Mar 23, 2019
- Messages
- 1
- Reaction score
- 0
Hello, I'm trying to learn how to enter Multiple results from a subform. I've inserted the subform into my main form already. So far the main and sub tables do not update together. I created a FK field in the main table to relate to the subform tables PK and set enforce, cascade update and delete. Also I have a date field in the primary table that I need the subform entries to relate too. Note main form set to Single, sub set to continuous or datasheet since Ive tried both.
To sum up my issues... Tables aren't updating together. I need the subform to filter entries by the date from the main form. Thanks in advance
To sum up my issues... Tables aren't updating together. I need the subform to filter entries by the date from the main form. Thanks in advance
Date(from Main?) | Customer | Job | Product | QtyOrdered | QtyShipped | QtyWaste |
3/23/19 | Cust19 | Job1 | Prod4 | 10 | 10 | 1 |
3/23/19 | Cust2 | Job10 | Prod2 | 3 | 3 | 0.25 |
>>>Footer>>>>>>>> | =Sum([QtyShipped]) | =Sum([QtyWaste]) |