Linking to 2 fields on another library

[Ivy Bogon]

I started working wih Memento a few days ago and I am impressed what it appears to be possible to do with this system.

I am an experienced computer user, but not an IT engineer or a programmer. 

My objective is to setup a system of Libraries to manage data in a small shop (customers, product and service catalogs and sales invoices) and I feel I already made significant progress since I started a few days ago, but I already spent many hours, making testes and searching the forum and I still cannot resolve a problem I have.

I have this Sales library (lines of an Invoice) :-

/ Field INV # Is extracted correctly from an Invoices Library.

/ Field Description extracts Correctly from the field Descrption in the Product Library.

/ Field Price extracts again Description from the Product Library and I have not been able to figure out how to extract the field Price from Product. As we can expect the calculation in Total (Price X Quantity) has an error message.

The result is:-

The Product Library Looks like this:-

Please help me learn how to extract the two separate fields from Products (Description and Price) into Sales.

Thanks in advance. IV

[Randy Seriosa]

I have this problem too. Can it be done?

[Gilles Mons]

You tried with Auto fille ? ?

Le mer. 4 déc. 2019 à 14:46, Randy Seriosa <serio...@gmail.com> a écrit :

I have this problem too.  Can it be done?

--
You received this message because you are subscribed to the Google Groups "mementodatabase" group.
To unsubscribe from this group and stop receiving emails from it, send an email to mementodataba...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/mementodatabase/cd939480-be57-4195-a61b-17ac5e09ecf6%40googlegroups.com.

[Er Mo]

Hallo
Hast du schon ein Berechnungsfeld versucht ? In der Formel des Berechnungsfelt können andere Felde ausgewählt werden . Achte auf die Anzeigeform ( Text , Zahl . Datum ...)

Hi
Have you already tried a calculation field? Other fields can be selected in the formula of the calculation box. Pay attention to the display form (text, number, date ...)