Hello All,

I am using the invoice starter solution, I add a Catalogue Field to the Invoice Data Table which is an (Text ; Indexed, Look up from related Table Products::Item)

I've been playing over the weekend but I cant make into work. If I put the Catalogue Number my item its not filling automatically.

Can you please help me. I have also attached the file that Im working for your reference.

Thank you 

Invoices.fmp12

Edited October 30, 20178 yr by Lola

Hi Lola,

Happy to help. Two things: uploads must be zip files and pls change your avatar. It's making me dizzy.

Hi Barbara, 

FileMaker  files do NOT have to be zip anymore, There is something wrong with the link. I believe this was cause by the SSL Certificate problem

Lee

Hi Bcooney,

Sorry for my Avatar. I will change it. I will upload try to upload the file again when they fix https://fmforums.com/announcement/10-ssl-certificate/

Thank you.

 

Hi Bcooney,

The file is uploaded. 

 

Thank you.

 

Invoices.fmp12

Edited October 30, 20178 yr by Lola

First of all, I think the Invoices Starter solution is not something you should use.  There are much better solutions.

In the portal, you're lookup for catalog number was based on item, it should be based on catalog number.  Also, it only works when you use the button to add a line item.  You can't type into the portal to change the catalog number and change the line items.

Hi Steve,

Thank you for the reply. Do you have any link that I can take a look?

Thank you