Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Trouble with SubForms
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...- keithhbs
- Thread
- Replies: 0
- Forum: Microsoft: Access Forms
-
Relationship produced unanticipated Query results
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) <------------| .... | |...- keithhbs
- Thread
- Replies: 3
- Forum: Microsoft: Access Tables and Relationships
-
Handling "Multiple Foreign Keys" in the same table
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...- keithhbs
- Thread
- Replies: 2
- Forum: Microsoft: Access Tables and Relationships
