After flying back over the Atlantic and having to interrupt my learning for some "real" work I've lost my budding understanding of FM and need some new handholding pls :-)
Here is my current initial TO structure:
and in context of the prodotto (product) table I want to have two fields filled up by selecting from another two tables as follows:
a) I need the "Aliquota IVA" (VAT %) showing a list of taxcodes::desc and when one is chosen store the corresponding taxcodes::__id_taxcodes_pk value
b) same goes for the Marca (Brand) field: select from a brand::name list and then store the brand::__id_brand_pk value
How do I setup this in either the Manage->Database dialog (tried a few things but they did not work out) or in the Layout inspector dialog (or whatever else I need to do) ?
I'd be happy to stop here to go in baby steps but then in the future I'd like to go further when I have to enter a NEW brand or TaxCode.
Again thanks a lot.