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 <[log in to unmask]> 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
>
|