Access Daily Entry with multiple entries per field


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])
 
Ad

Advertisements


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

Top