The id # is just a record number, you can let access just assign them 
sequentially (1,2,3,4...).
I would recommend a separate database for clients and rentals. You can 
always crosslink the records if one person both rents something and 
comes for a consult.

I so wish Microsoft had not won the office suite wars, Approach 
(purchased by lotus a zillion years ago) was so much more user friendly.

Catherine Watson Genna BS, IBCLC  NYC  cwgenna.com


On 4/6/2011 11:08 AM, Jaye Simpson, IBCLC wrote:
> Hi All,
>
>
>
> Not exactly breastfeeding related - but breastfeeding business related
> questions for you all.
>
>
>
> I just got Access 2010 and would like to know what type of databases those
> who use Access are setting up.  Apparently each client needs a personal ID#
> - what did you come up with?  What type of information can you track?  I
> have not only clients, but rentals and retail.  Can Access be used in
> conjunction with or in place of Quickbooks?
>
>
>
> Bottom line: I know nothing about Access and am learning from scratch.  My
> partner is studying it also as she loves this kind of thing and acts as my
> part-time admin.  :-)  Any input, ideas, etc. would be helpful!  Thank you
> so much!
>
>
>
> Please respond privately to:
>
>
>
> [log in to unmask]
>
>
>
> Jaye Simpson, IBCLC, CIIM
>
> Breastfeeding Network
>
> Sacramento, CA
>
> www.breastfeedingnetwork.net
>
>
>
>
>               ***********************************************
>
> Archives: http://community.lsoft.com/archives/LACTNET.html
> To reach list owners: [log in to unmask]
> Mail all list management commands to: [log in to unmask]
> COMMANDS:
> 1. To temporarily stop your subscription write in the body of an email: set lactnet nomail
> 2. To start it again: set lactnet mail
> 3. To unsubscribe: unsubscribe lactnet
> 4. To get a comprehensive list of rules and directions: get lactnet welcome

             ***********************************************

Archives: http://community.lsoft.com/archives/LACTNET.html
To reach list owners: [log in to unmask]
Mail all list management commands to: [log in to unmask]
COMMANDS:
1. To temporarily stop your subscription write in the body of an email: set lactnet nomail
2. To start it again: set lactnet mail
3. To unsubscribe: unsubscribe lactnet
4. To get a comprehensive list of rules and directions: get lactnet welcome