Access Daily Entry with multiple entries per field

W

williamson1979

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

Date(from Main?)CustomerJobProductQtyOrderedQtyShippedQtyWaste
3/23/19Cust19Job1Prod410101
3/23/19Cust2Job10Prod2330.25
>>>Footer>>>>>>>>=Sum([QtyShipped])=Sum([QtyWaste])
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Use field to update multiple fields 4
Subform Multiple Entries 1
Access "Enter parameter value" popping up in Access form 3
Limit data entries 2
Form for Data Entry 2
Multiple subforms 0
Main \ Sub Form Data 1
Tab Control with multiple subforms 4

Top