Needless to say, I solved my problem a couple of minutes after sending my message. I don't know if I have the best solution, but it seems to work... -- AB
On 17 mars 2013, at 13:45, Andrew Brown <[email protected]> wrote: > I am trying to make sense of a database of a large number of letters written > by one or more people to one or more people, for example : > > Letter 123456 from John and Sue to Dave and Jane > > In the table of people, John, Sue, Dave and Jane are numbered respectively > 100, 101, 102 and 103. > > Since the number of people can vary, I have a table linking the letters to > the people. It records the letter number, the person number, and a number for > the role of the person, sender (1) or receiver (2): > > 123456 100 1 > 123456 101 1 > 123456 102 2 > 123456 103 2 > > So I have three tables, one for the letters, one for the people and one for > the links. > > On the main letter page I have two filtered portals based on the links table, > one showing the names of the senders and one showing the names of the > receivers. This is fine, except that I cannot add records to the portal since > FMP will not allow the modification of the field containing the sequence > number of the people. > > I have several thousand people, so need to have drop-down lists in the > portals. > > I guess there must be a solution, but I can't find it! > > Andrew Brown >
