Auto enter

[Lola]

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, 2017 by Lola

[bcooney]

Hi Lola,

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

[Lee Smith]

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

[Lola]

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, 2017 by Lola

[Steve Martino]

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.

[Lola]

Hi Steve,

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

Thank you