Hi - I have a communication log with that allows a user to keep a separate log every time they have contact with a youth. It tracks the time and date and a topic and particular staff person.

This works by Committing the Record to the "communication" table from the "youth" table.

It works perfectly locally, however, when done with IWP - the log is somehow duplicated. It will give the correct ID for both logs. But in one log, will be the date and time (which are automated on creation) and in the next log - it will have the correct ID -but only have the staff, topic and note.

How can this be fixed?

Also - Can someone help me with a solution to combine all the logs - so a person could read "Joe Smith's" entire history as an option.

Let me know what does not make sense and thanks much in advance.

Let's start with the tables you have. I'm assuming:

Staff

Youths

Activities (Log)

When you create a new Log record, you write the StaffID, YouthID and a log note.

How do you know the StaffID? Do you capture it when the Staff member logs into the system?

Why can't you read Joe Smith's log history? It would be a portal from the Youth record (Joe Smith's) to the Activities (Log) by YouthID.