The Location (amLocation table) field linked to my amPortfolio table is set to Mandatory. Whenever I supply a User (User is mandatory on 'In use' status in my case), I get the following error for the Location field:
Error: Field 'Location (Location)' in table 'SET Equip (amPortfolio)' cannot be empty.
One work-around is to give it ANY location, other than the one it currently has. Save it, then give it the desired location, which works. But that's ridiculous, it should work with the desired location without having to do this work-around. Can anyone help! Any suggestions?
See screenshot attached for a visual explanation (Steps 1 & 2).