Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi
I have a table with columns TeamHome and TeamAway and there is a table called Team which includes all values from the TeamHome and TeamAway columns. What I want to have is that on the frontend is a listbox where I can choose between several teams from TeamHome and TeamAway in one Listbox. How to build a datamodel which can do this without an syn table?
Thankss !
Maybe like this using CROSSTABLE LOAD:
Fact:
LOAD recno() as ID, * INLINE [
TeamHome, TeamAway, GoalHome, GoalAway
1, 2, 2, 0
];
CROSSTABLE (Location, Team)
LOAD ID, TeamHome as Home, TeamAway as Away
Resident Fact;
Team:
LOAD * INLINE [
Team, Name
1, Germany
2, Italy
];
Further reading:
Perhaps this tutorial on alternate states helps: Using Alternate States to Select Multiple Values in a List Box with Different Attributes