Get(AccountName) in a relational database...returns 'Admin' on each networked PC
Hi...and thanks for taking time to help me!!:smileywink:
- My 'main' database (A), uses a couple fields from another database (B) (relational database)
- One of those (B) fields is a "Auto-enter Calculation", which check this condition: "If (Field1 = "Yes" and Field2 ≠ ""; Get(AccountName))"
The problem is that, when working on a networked PC, connected to the database, with a user name "Bob": when the condition is met, this is "Admin" which is returned in the field...not "Bob
Hope that I'm clear, english isn't my mother tongue ;-)
Thanks very much for your help!!
FM Pro 10 - Windows XP