Update query question

[YamiMarik777]

I have three tables. I have Vendor Name table w/ vendor#(p-key), vendor.I have a VendAlias table that has Vendor, Vend#(both fields are p-key). They have a one-to-many relationship. Next , I have an invoice table that has stmtdate, posteddate, transdate, Vendor, Vend#. I want Access to fill in Vend# in the Invoice table utilizing the VendAlias table. I thought about using a Lens() function because for instance, in the Invoice table vendor is HP services, but in the VendAlias table it could be HP products, HP online, etc. I am doing all of this to generate reports that total are grouped vendor by all of its invoices. Any help I would appreciate. Thank you.

 

[YamiMarik777]

Re: Pat Hartman

Thank you for the into. I need more explaination of combo. Do you mean create a combo box in report design view??

 

[YamiMarik777]

Thank you for replying. These are things I want Access do. I want the user to be able to check a box off to show the Invoice is Paid and in the datasheet put in Date/Time in the DateModified and TimeModified field. I want to be able to print out a report that shows all invoices paid and unpaid. I want to be able to count all the invoices under one VendNum. I thought to have Access using grouping you have to establish a relationship. I have attached my relationships and attributes/datatype of all my tables. Please help I have a deadline for Friday evening. Thank you.