Multiple tabs

[Jeff]

Hi
I am trying to set up a database for client records. I want to view it in a form. So far I have one tab for client details and one for my treatment notes. I have twenty-one tabs all up (20 treatments). The problem I have is that when I add the third tab all the data is copied to the next client, yet if I only have one extra tab everything works fine. This is all good if I only want one client treatment recorded, but I want multiple i.e 2nd tab first treatment, 3rd tab second treatment etc.
Am I doing doing something wrong here or can this just not be done the way I want it?

Any help would be greatly appreciated.

Thanks in advance

Jeff

 

[pono1]

I think you want to use a main form and subform...not tabs...if, that is, you are trying to work with clients and their treatments where one client may have 0 or more treatments... In Access Help, search on create SubForm in the index where you can read up a little more on this.

Regards,
Tim

 

[Jeff]

Hi Tim,

Thanks for your reply. I tried subforms, they're not as "pretty" but do the job and that's the main thing.

Thanks again

Jeff