Hi everyone! Newbie here! I'm working on a solution to a donation inventory problem for a non-profit food pantry using FM 10 Pro. I have a main table (data entry) with the "item name" and "cost." This looks up from another table (donations) to find the item and copy the price into the "price" field on the data entry form, then use that for a calculation. Is there any possibility that I could set it up so that the field on the data entry "item name" would look for it on the "donation list" AND, if it is not found, copy the information as typed on the "item name" and "price" back into the "donations list," thereby populating the "donations" list with any item not present at that moment.
I realize that this is causing data to flow both ways. Is that possible???????