I'm having a problem with a form I am creating. I want to have the form select a record from a combo box and display all the fields for one record from one table and some related information from two other tables.
It works just fine when I am only working with fields from one table but when I try to add fields from another table the records stop changing when I make a new selection in the Combo Box.
I have 3 tables:
tblProject(ProjectName, ProjectNumber, ProjectDescription, tblClient.ClientName, tblClientContact.ContactName)
tblClient(ClientName, StreetAddress, City, State, Zip Code)
tblClientContact(ContactName, PhoneNumber1, PhoneNumber2, EmailAddress, tbl.Client.ClientName)
When I create a form using just the tblProject and use a combobox to select a Project name and Number to navigate through records everything works just fine. If I add the tblClientContact.PhoneNumber1 field to the form (as related to the appropriate client contact for that project) or the Address field from the client table, everything breaks. Selecting a project name or number from the combobox does nothing except change the field in the combo box.
I am very new to access (less than 20 hours) so let me know if I should be supplying more/different information.
Thanks!