I'm new to Xataface and am quite impressed so far.
I've build asp apps using vbs and am just learning php.
I'm working on using Xataface to build a monthly reporting app for some grant-funded programs.
The big picture is I will need to determine what users see and can do based on their login (haven't gotten to that point yet) and since it's a multi-year project will need need to selectively display info based on the fiscal year as well as selected reporting month and year.
I'm just now to the point of defining tables using the fields, valuelists, and relationships inis.
I need to set the default report month and year which I plan to do using current month and year. and display that as a select list with the default being current month and year. I have a look up table set up with year, month and fiscal year. I'll need that selection to be a global value that i can use in multiple places to help decide. What's the best way to go about doing that?
Also, I'm having trouble with relationships. I have a main Programs table and multiple other tables (one to many) e.g. program staff, goals, objectives, etc that contain ProgramID as the foreign key.
I tried this,
/tables/Programs/relationships.ini
[Programs]
ProgStaff.ProgramID = "$ProgramID"
ProgGoals.ProgramID = "$ProgramID"
ProgObj.ProgramID = "$ProgramID"
RptProgData.ProgramID = "$ProgramID"
etc
but it appears to only work with one relationship at a time and hoses with all of them listed. What am I screwing up?
I haven't tried this year, but am I on the right track that each has to be named?
[Programs_Staff]
ProgStaff.ProgramID = "$ProgramID"
[Programs_Goals]
ProgGoals.ProgramID = "$ProgramID"
Thanks,
Betty