Community
Showing results for 
Search instead for 
Do you mean 
Reply

Sub-database (Excel) for my ACT??

Copper Contributor
Posts: 62
Country: USA

Sub-database (Excel) for my ACT??

I have a  custom ACT database with about 1000 of my customers and their vehicles.

Each customer may have 1 to 4 vehicles.

Each vehicle may have up to 4 operators

Each operator may be on multiple vehicles for multiple customers.

 

I don't have a good way to globally track, update maintain operator statistics and qualifications.

Any suggestions?

 

I thought about an ADD-ON Tab with an Excel DB.

Then I could somehow pull that current individual operator data to multiple customers and vehicles.

But just have the operator updates in one place.

 

Any input would be greatly appreciated.

W7u-32 / Act 2010 Premium / Office 2007

Tj

**************
Phoenix, AZ
4 user Act 2011HF5
W7 (32&64) on a W7-64 "Server"
Outlook 2003 and 2007
Platinum Elite Contributor
Posts: 6,669
Country: USA

Re: Sub-database (Excel) for my ACT??

You need a custom table plugin. Check with either http://www.toplineresults.com/ or http://www.durkincomputing.com/

Roy Laudenslager
ACT! Certified Consultant
ACT! Report Expert
Durkin Impact Report Designer
www.techbenders.com
royel@techbenders.com
541-343-8129
Nickel Elite Contributor
Posts: 508
Country: USA

Re: Sub-database (Excel) for my ACT??

TopLine Designer is what you want to get - it's a great AddOn for this purpose, and it's simple to "develop" solutions just like you describe.  Hope this helps...

Richard Brust
ACT! Certified Consultant
richard@rbrDataSolutions.com