Hi FM community
After login with specific Account Name to DB, I would like to get Customer number from related Table. It look like this:
Parent:Customer_PK -> Child::CustomerEmployye::fk_Employye
Customer: PK <->Child::CustomerEmployye::fk_Employye <-> Child::CustomerEmployye::EmployyeName
So if I will login as "Worker1" (OnFirstWindowOpen), and this worker is related to "Company1", I would like to get this Customer number from Parent:Customer table into global variable, so I could use that numer while creating orders. I already have $$User = Get (AccountName), but I dont know how to connect this variable to get customer number also into next variable.
Thanks in advance.