AnsweredAssumed Answered

Art Gallery Database - portal field?

Question asked by 6days on Aug 8, 2018
Latest reply on Sep 6, 2018 by philmodjunk

Good morning everyone,

 

I hope I can explain this understandable. I am not very good with FileMaker (using FileMaker Pro 16), I just started a few weeks ago teaching myself, so this may be two very basic questions but I just can't make it happen. Here is what I would like to do:

 

1. I have a table "Inventory" and a table "Contacts" and I would like to be able to connect certain records from the inventory with the contacts. For example, let's say a contact is interested in an artwork, I would like to be able to make a note in this record ("Inventory") and for it to then also show up in the other record ("Contacts"). Also it would be nice if we could click on the entry and then go directly to the related record. I was able to do this with "Payments", but for some reason I am doing something wrong now.

 

2. From "Payments", I tried to do a direct preview from the payment record to the actual invoice. It does open a preview of the invoices, but it is always the same invoice popping up and not the related record?

 

I hope somebody can help me!

 

Screen Shot 2018-08-08 at 09.18.48.png

Screen Shot 2018-08-08 at 09.19.17.png

Screen Shot 2018-08-08 at 09.50.58.png

Screen Shot 2018-08-08 at 09.26.23.png

Outcomes