11-20-2008 11:51 AM
I have a database comprised of travelers. I set up a new TAB called Trips. One person might take many trips. Need to save the data for each trip and be able to have relationship between the traveler and all of his trips. Can you point me in the right direction for setting this up?
11-20-2008 12:54 PM
11-20-2008 01:52 PM
11-20-2008 02:03 PM
11-20-2008 04:57 PM
Roy & Xavier,
Thanks to both of you. I'll check out both programs. It's too bad Act! requires addons to do something as important as setting up one-to-many relationships. Ten years ago FoxPro used to handle it so well.
11-20-2008 10:35 PM
11-22-2008 07:35 AM
It took forever for me to locate the sdk, but I finally found it. And you're right -- it's much more cost effective to purchase one of the addons. But I have to say.... After 11 iterations of this program, you might think they would provide simple database operations without requiring someone to buy their program, and then find out afterwards that they have to spend more money to make it do anything useful! At this point, I'll probably purchase CRM software that has been fully developed to meet my needs in my industry.
Once again, Roy, thanks for your help and support!
11-22-2008 10:15 AM
Just a thought before we get too involved with custom tables.
ACT 11 allows you to have custom activities, why not create one called trips?
Use the activity area to log the trips, you will have the date, duration etc, subject can be the Destination.
You can run reports and even associate with groups of different countries.
Not sure if this is enough for your needs but I always look for the most simple solution.