Right now I just have 1 application, with a small account in it, it's about 1,000 records... But I plan on marketing the program which would (Hopefully) increase the user base and total records. I could see having 20-30 customers with all with around 1,000 to 30,000+ names in the database. At least that's what I'm hoping for.
Well that's easy:
+----------------+
| Accounts |
+-------+--------+
| ac_id | ac_foo |
+-------+--------+
|
| +------------------+
| | Names |
| +---------+--------+
+----> | na_acid | na_foo |
+---------+--------+
How's that for ASCII art? :-)
--
Richard Heyes
+----------------------------------------+
| Access SSH with a Windows mapped drive |
| http://www.phpguru.org/sftpdrive |
+----------------------------------------+