Hi, thanks for the input,
i believe i found a much smoother way of doing this. there is big chance I'm wrong but this is what i made instead.
The people that are going in to the database are journalists, reason for several companies, as you mention the problem as well is for what company did they attend. The whole purpose here is to be able to look at a journalist and see what he or she has done and as well for a newspaper.
I made three tables, Journalists, Companies and Events.
The first two tables have their specific info and the third one is sort of a list.
It lists date, name, company, event and specific info about the visit. Then I related the name with the name of the journalist and company name in the same way. This worked perfectly. At the journalist layout a portal collects the info about the events that person has done and for which companies, the same for companies.
This works almost perfectly except a small detail in the portal. Lets say I have person John Smith, and I want to add an event for him, I do that, and the company he attended for already exist I create a duplicate of that company. This can be solved by not letting the event table create posts in the company table, but that is not a good solution since there will be new companies coming so to speak, and then I would have to first create a post for the company, and then adding his record for the event, or the other way around.
So is there a way that I create new posts in a table through a portal If the name or particular info doesn't exist, otherwise not?
