multiple log records agains an event (1 Viewer)

MattF

New member
Local time
Today, 15:07
Joined
Oct 20, 2013
Messages
2
Hi all,

So I have an event table with a muti value field with all the people on that event. This people field is look up column from my people table (so shows the name but stores the key).


Anyhow what I now need to to do is record logs from the event for each person (from that muti value people field). I want ideally be prompted to enter the log data for each person, and show it related to the event it is for.


Any bright ideas? And thanks in advance :)
 

jdraw

Super Moderator
Staff member
Local time
Today, 11:07
Joined
Jan 23, 2006
Messages
15,364
The only thing I can suggest is "do not use multivalue fields". Normalize and design the table with multiple records, not a field with multivalues.
You would need a unique compound index on such a table.
In overview you would need to record info for

The event log record identifier, the event, the person, possibly the date, and some code or text describing the issue/purpose of the log record.
 

Users who are viewing this thread

Top Bottom