Related Record (11.8166.8172 (2003))

[bbrown5]

I thought I was creating a very simple database w/ form however I am not seeing what my problem is. Attached are screen shots of relationship, form and error message. Any help appreciated.

[HansV]

You cannot enter any data into the subform before you have created a record in the main form. The Employee Name combo box in the main form is empty so I assume that there is no record in the main form yet. Try selecting a name in the combo box, then entering some data in the subform.

[bbrown5]

The Employee name combo box does have a listing of names.

[HansV]

I'm afraid that doesn't say very much. Could you post a stripped down copy of your database? See <post#=401925>post 401925</post#> for instructions.

[patt]

The join on those tables, are they on EmployeeID to EmployeeName??

[bbrown5]

yes.

[johnhutchison]

Well it should not be.
In tblVisit replace the EmployeeName field with an EmployeeID field (long integer) and use that field in the relationships to connect tblVisit with tblEmployee.

[bbrown5]

Here is a stripped down copy.

[HansV]

Both the main form and the subform are based on tblVisits. This makes no sense. The main form should be based on tblEmployee, and the subform should be linked to the main form on EmployeeID - you want to see the visits for an employee, I presume.

See attached version.

[bbrown5]

Thank you very much. Your response was how I had attempted however was not sure that it was correct. Again, Thanks!

Another issue. Attached is a snapshot of the last page of a report where I would like a summary of various codes for each of the month and a total. I tried count and DCount in various ways but have not come up w/ the right combination. Suggestions, please.

[HansV]

You can use crosstab queries for this. However, the column headings in a crosstab query can change over time, and this makes it more difficult to base a report on such a query. If you search this forum for dynamic crosstab report, you'll find examples.