Yes you can !! My application does it all the time all my records are natural linked. ALL mine are in the same database.
![Wink Wink](https://www.lantica.com/Forum5/public_html/yabbfiles/Templates/Forum/default/wink.gif)
Here is some code not pretty but it works.
If @Update and (Loc0 = 1) then
{
xpost(@Fn,Part number,"Mastinv!Item number",Qty0,"PHA1","Sub")
}
else if(Loc0 = 2)
{
xpost(@Fn,Part number,"Mastinv!Item number",Qty0,"PHA2","Sub")
}
else if(Loc0 = 3)
{
xpost(@Fn,Part number,"Mastinv!Item number",Qty0,"PHA3","Sub")
}
else if(Loc0 = 4)
{
xpost(@Fn,Part number,"Mastinv!Item number",Qty0,"Vict","Sub")
}
If Loc0 = 5
{
xpost(@Fn,Part number,"Mastinv!Item number",Qty0,"Shop","Sub")
}
Else
{
If (Loc0 >5) then Writeln("Didn't Work")
}