Search results for query: *

I am having trouble with a new subform in a program that has been working just fine. A requirement changed which I felt could be solved by adding this subform (and an underlying Table - "tblSalesRepOrders"). The name of the Main Form is "frmOrders". There are already 3 "tabs" on this form...

Sorry to do this, but you asked for it ("tblOrdersAgent" is what I previously called "tblOrders"): THIS ONE WORKS: SELECT tblOrdersAgent.OrderDate, tblOrderDetailAgent.[Order#], tblOrderDetailAgent.[Unit#], Year([OrderDate]) AS OrderYear, Month([OrderDate]) AS OrderMonth...

A portion of my tables/relationships is shown below: PK=Primary Key; fk=Foreign Key; ... indicates there are more fields not shown; the dotted line shows a relationship that was removed. tblSalesperson SRInitials (PK) <------------| .... | |...

Ken - I did not realize that this was an option. It appears to me that this new table (SalesRep_1) is a clone of the the SalesRep table. I am assuming that any changes to "SalesRep" also appear in "SalesRep_1"? This is pretty slick. After sending the initial question I started thinking about...

Although I am fairly new to Access and VBA, I understand relationships fairly well. But I have a situation that I am unsure how best to approach. In the Order File I have already defined a Foreign Key for the Sales Rep that ties back to the Primary Key in the Sales Rep File. I later realized...