Hi Anton,
Ed's idea worked for me, but I found a serious flaw in my implementation. When I designed my database (native VFP), I took AutoInc for my PKs. HUGE mistake! Now I'm in a catch 22 situation, because after I inserted a new record in a table I can not get my PK back. It looks like I have to switch to NextID() for now and use GUID in all other new projects instead.
>>Hi everybody,
>>
>>I have a ProblemResolution table with 3 integer fields PK, FK1, FK2. In theory, a Problem may have multiple resolutions and vice versa. For now, I have them as 1 to 1.
>>
>>I'm thinking what would be the simplest and most intuitive interface for this table maintenance? Or should I probably combine maintenance of Problems, Resolutions and ProblemResolution in one form?
>>
>>Appreciate your valuable insights.
>>
>>Thanks in advance.
>
>Maybe a "pivot table" where, for example, rows represent problems and columns represent solutions and may be useful. In this case checkboxes in cells will represent problem-solution connections.
>But if there are large numbers of entities this will probably need dynamic generation of column set and order.
If it's not broken, fix it until it is.
My Blog