I'm new to FMP and just in the planning stages. I have numerous main tables inc Contact, Property & Journal and I want to be able to create a related record in a Tasks/Schedule Table from each of these. Should I just simply have a separate foreign key field from each of Contacts, Propery & Journal? And therefore only one these fields completed in each record.

You can use script variables or script parameters using multi-key (passing various values using carriage return symbol, then parsing at the other end). However, it all depends on your solution, basically, what does your solution aim to achieve and how best to allow users to interact with the solution.

There are cases where a portal would perfectly/effectively solve the problem, simply include a check-mark on "Allow creation of records in this table via this relationship."

Edited January 29, 200817 yr by Guest
noted user is a beginner

Thanks for your post.

The Tasks table will contain To Dos with a start, end and reminder date. These to dos will each relate to a either a Contact, a Property or a Journal. Therefore, I want to be able create a record in the Tasks table from each of the other tables and for them to link back.

You are asking a difficult question for which there is no correct answer. It depends on a lot of details which we do not know. My inclination is to say go with separate foreign keys - if only because it will enable a task to be related to a contact AND a property, for example.

Of course, this raises the possibility of a task that needs to be related to multiple contacts - and now you know why I said this is a difficult question.