Help with linking (?) subform

[cds11]

Please bear with me. I have been playing with this for a little while, and while I feel I am almost done, there are a few little quirks that I would like dealt with....

Can I get my table associated with my subform (CustomerOrderDetails) to be filled in with the company information that is collected into the main form/table (CustomerOrder)? Does that make sense? Same for putting VendorID in PurchaseDetails.

I have attached what I have so far....

And, is there a way to have it all fill in the "Inventory" table so that I can easily look there to see how things have come and gone (which purchase order, what customer order it went out on)? Or is that asking too much and I should just do some kind of query?

 

[cds11]

Did I post in the wrong spot? Am I not making sense? I would really appreciate some help here... Please let me know if something needs clarifying

 

[Scooterbug]

I'd take a look, but I dont have access 2007.

However, having an inventory table rasies a flag or two. The easiest way to calculate inventory is to have a start point of inventory. From there, you add up everything that came in and then subtract everything that went out.

Trying to maintain a table can be a bit difficult. I made that mistake a while ago, and it caused nothing but heartache when an input error was made.

 

[cds11]

So, I have manged to figure out how to get my additional info copied like I wanted it to. All I had to do was look a little harder in "Properties" while in Design View of the form, with the Subform name selected (ie. CustomerOrderDetails) and just add in the additional field (ie. CompanyName) that I wanted matched for Master and Child (in Data tab).

I'm not really as concerned about the Inventory table I guess... I can just use Reports and Queries to look things up, right?

 

[David Eagar]

It will work better if you have your CustomerOrderID as an autonumber, same in details

 

[cds11]

Unfortunately I cannot have CustomerOrderID as Autonumber as it needs to relate to our other system where the orders are generated, this is merely to keep track of what went where and when kind of deal.