Showing results for 
Search instead for 
Do you mean 

Sub-database (Excel) for my ACT??

Copper Contributor
Posts: 65
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


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

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

You need a custom table plugin. Check with either or

Roy Laudenslager
ACT! Certified Consultant
ACT! Report Expert
Durkin Impact Report Designer
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