Although this is the first (second?) time I am writting here, I have been reading the forum from a lot of time ago.
First, excuse me for my very bad written english as I am spanish. I can read in english better than write.
I have been developing programs for more than 20 years. First in Basic, Cobol and when dbase appeared, in Clipper, then in VBasic finally in Access.
After stop programming for the last ten years, I have decided to start again, but need a new RAD developing tool like Alpha. I choosed Alpha betwen Runtime Revolution, WinDev (very good but very expensive), Foxpro, Omnis a others.
I have a license of the enterprese edition and what I need at the moment is a desktop program for my customer (he is my best friend).
This is a program to control liferafts inspections and I works with 3 different related tables:
- Ship owners
- Ships
- Liferafts
The relation between tables are 'one to many' in all cases (one ship owner can have several ships, one ship can have several liferafts)
For the first instance I need a grid with the following info:
Ship's name - Ship's owner - number of liferafts in the ship
The grid should be in a tabbed object with 3 tabs. When clicking in the second tab should show the complete list (grid or list-box) of liferafts (relevant info) in the selected vessel in the first tab. When clicking in the third tab, should show all the info of the selected liferaft.
I can do that using an SQL statement, working with Alpha Five using external link tables (in Access), but I don't know how to construct that with Alpha.
Any help? Thanks in advance
Jose
First, excuse me for my very bad written english as I am spanish. I can read in english better than write.
I have been developing programs for more than 20 years. First in Basic, Cobol and when dbase appeared, in Clipper, then in VBasic finally in Access.
After stop programming for the last ten years, I have decided to start again, but need a new RAD developing tool like Alpha. I choosed Alpha betwen Runtime Revolution, WinDev (very good but very expensive), Foxpro, Omnis a others.
I have a license of the enterprese edition and what I need at the moment is a desktop program for my customer (he is my best friend).
This is a program to control liferafts inspections and I works with 3 different related tables:
- Ship owners
- Ships
- Liferafts
The relation between tables are 'one to many' in all cases (one ship owner can have several ships, one ship can have several liferafts)
For the first instance I need a grid with the following info:
Ship's name - Ship's owner - number of liferafts in the ship
The grid should be in a tabbed object with 3 tabs. When clicking in the second tab should show the complete list (grid or list-box) of liferafts (relevant info) in the selected vessel in the first tab. When clicking in the third tab, should show all the info of the selected liferaft.
I can do that using an SQL statement, working with Alpha Five using external link tables (in Access), but I don't know how to construct that with Alpha.
Any help? Thanks in advance
Jose
Comment