Community
Showing results for 
Search instead for 
Do you mean 
Reply

Is is possible to set up a one-to-many relationship?

New Member
Posts: 4
Country: United States

Is is possible to set up a one-to-many relationship?

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?

 

Thanks!

Platinum Elite Contributor
Posts: 6,651
Country: USA

Re: Is is possible to set up a one-to-many relationship?

Yes if you are using version 10.0.2 or later, you can add custom tables to the database using one of several addons for that.
Roy Laudenslager
ACT! Certified Consultant
ACT! Report Expert
Durkin Impact Report Designer
www.techbenders.com
royel@techbenders.com
541-343-8129
New Member
Posts: 4
Country: United States

Re: Is is possible to set up a one-to-many relationship?

Thanks for your quick response, Roy!

 

I'm using 11. Could you be more specific about which addons and where I can find them?

 

Thanks!

Bruce

Nickel Contributor m4y
Nickel Contributor
Posts: 511
Country: Belgium

Re: Is is possible to set up a one-to-many relationship?

Havea look at TopLine Designer Smiley Wink

Xavier Nyssen

ACT! Certified Consultant @ Intuitis | Belgium
{ +32 64 45 08 00 | xavier@intuitis.be | http://intuitis.be }
Platinum Elite Contributor
Posts: 6,651
Country: USA

Re: Is is possible to set up a one-to-many relationship?

I'm partial to Tablemaker Pro, it's straight forward without an excess of bells and whistles and easy to configure..
Roy Laudenslager
ACT! Certified Consultant
ACT! Report Expert
Durkin Impact Report Designer
www.techbenders.com
royel@techbenders.com
541-343-8129
New Member
Posts: 4
Country: United States

Re: Is is possible to set up a one-to-many relationship?

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.

 

Thanks again!

Bruce

Platinum Elite Contributor
Posts: 6,651
Country: USA

Re: Is is possible to set up a one-to-many relationship?

Actually ACT! does not require an add on, the custom table capability is built into the ACT! program and is available through the SDK interface and you are welcome to do the programming yourself to implement adding custom tables to the ACT! database. I think you will find that investing in one of the addons will be more cost effective than doing your own programming. It's likely that a future version of the ACT! program will include a native module to configure custom tables.
Roy Laudenslager
ACT! Certified Consultant
ACT! Report Expert
Durkin Impact Report Designer
www.techbenders.com
royel@techbenders.com
541-343-8129
New Member
Posts: 4
Country: United States

Re: Is is possible to set up a one-to-many relationship?

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!

 

Bruce

Bronze Elite Contributor
Posts: 1,409
Country: United_Kingdom

Re: Is is possible to set up a one-to-many relationship?

Hi

 

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.

 

Regards

 

Chip.