The first one is that in my "Invoice Detail layout" I had a value list with the colors and the sizes related to each product, now is not working any more. I dont know if I'm doing something wrong because it tells me "List without values", and also I have the field of "description", were it suppose to appeare when I select the product Id.
The secund issue is of the inventory by store.
1.- I have my inventoriy of clothes with a value list of multi colors and multi sizes, related to each product. Now I need to add the location (store) there the inventory is located, so I can see were I have the product, so If I need that product in the store 1, I can see in whitch store i can take it from.
The question is how can i do to make a formula, so when I pass a product from the store 1 to the store 3, It sums in the store 3 and to substract it from the store 1.
2.- How can I relate a field so I can only make an invoice of what i have in stock? If I dont have in stock I dont want that it lets me choose the product.
Thank you very much and I attached the compressed file so if you need to see how are my table relationships