Hi, how about you List (Active Ingredient Table::Name) them together?
I tried it but it just appear the 1st Active Ingredient, I can't see the 2nd or more.
UPDATED, it worked, but in a List way, isn't there any other method with a , to divide between Ingredients?
easy: Substitute ( List (Active Ingredient Table::Name) ; "¶" ; ", " )
Hi again samermb,
Is there anyway to do this as inverted.
I have an Ingredients table with ID, and Ingredient Name, and then on the Medicines table I have the ID, Med_name and the Ingredients Names per medicine in a list, I want to make a new field and to change that ingredient name to the respective ingredient ID from the Ingredient table.
Is it viable?
Thank you again