It's probably a basic question for most here.
I have 2 tables:
people and projects
in the people table i have a field containing several projects they are involved in, separated by comma. (i also have a automatic field where the commas are changed into carriage returns)
now all I try to do is a button that opens a window and displays all of the projects involved in a project-layout. so it should find 4 records, or 3, depending how many projects that person is involved in.
For some reason I can't get this to work.
Opening the window and all this is fine, but it never works with more then one project.
If i make find requests with just the content of that project field it doesn't find anything.
couldn't say I'm a very experienced fm user.
thanks in advance