Show two tables in one view
Hi there - has any body tried to do this and how will it be done ?
The case is that I have a table for purchases (Danish name "Indkøb") An a table for Sales (Danish "Salg"), and I want to show them in the same view so I can make a graph showing the progress in the inventory for each article.
I guess I have to create a Phantom table containing fields Fram both tables - the inventory I created is taken from the official template in Ninox with some changes which suits my needs, but the data structure is quite the same.
rgds
Leo
6 replies
-
Hi, could you create a small demo database with just the two tables and the type of relationship between them?
-
Hi Sotirios
promised to get back to you - I created a Phantom table and use this script in a button in the Dashboard - and it works. (off course when I place this in the cloud I will do the script with "do as server". Right now I have it on my Mac.
delete (select Lagerhistorik);
for j in select 'Indkøb' do
let Xdato := j.'Ordre hos leverandør'.Leveringsdato;
let Xordre := j.'Ordre hos leverandør'.'Ordre Nr.';
let Xantal := j.'Antal i ordre';
let Xvnr := j.Vare.'Vare Nr.';
let Xvnvn := j.Vare.Varenavn;
let Xdel := j.Delleverance;
let Xstatus := j.'Ordre hos leverandør'.'Ordre status';
let Xremark := j.'Ordre hos leverandør'.'Bemærkninger';
let Xid := (create Lagerhistorik);
Xid.(
Dato := Xdato;
'Købsordrenr' := Xordre;
'Vare Nr.' := Xvnr;
'Antal købt' := Xdel + Xantal;
'Vare navn' := Xvnvn;
Status := Xstatus;
'Bemærkninger' := Xremark
)
end;
for j in select Salg do
let Xdato := j.Salgsordrer.'Faktura dato';
let Xordre := j.Salgsordrer.'Faktura Nr.';
let Xantal := j.Antal;
let Xvnr := j.Vare.'Vare Nr.';
let Xvnvn := j.Vare.Varenavn;
let Xstatus := j.Salgsordrer.Kunde.Status;
let Xremark := j.Salgsordrer.Kunde.'Bemærkninger';
let Xid := (create Lagerhistorik);
Xid.(
Dato := Xdato;
Fakturanr := Xordre;
'Vare Nr.' := Xvnr;
'Antal solgt' := Xantal;
Status := Xstatus;
'Bemærkninger' := Xremark;
'Vare navn' := Xvnvn
)
endNow I will investigate the E-chart and your version 5 of the Dashboard, as I agree with you that the native graphs in Ninox could be better.
Thanks for your help
Regards
Leo
Content aside
- 1 mth agoLast active
- 6Replies
- 63Views
-
2
Following