Tab control

firewall_ie

Registered User.
Local time
Today, 23:13
Joined
Mar 31, 2003
Messages
20
Hi,

I am trying to set up tab controls to save room on my database. I am trying to link two tables with realted information on clients can someone give advice.

Regards

Aaron
 
tab control

Yes I have sub forms on each page. But the way I want it to work the all the information on each page relate to the clientID field in each table so that i can have the personal information on one page and other tabel relating to their attendace, appointments etc.....

I hope you understand what I am trying to do, I am new at database. Well new to the code end
 
So you have the personal details on page one and attendance details in a subform (is this hospital attendances?)

What are you actually saying? the subforms don't work?

Col
 
YEs they are working. Right I will explain. I have a number of tables personal details, attendace details, clinic details. I have made all of these into forms. I created a main switchboard form with tab control pages, on page one I have the personal details page two is attendace record page three clinic details. When adding or view client information I need all the information in the main form a subforms to relate to each user as they are created or changed. I can not get each tab control page to relate to one client. I hope you understand what I am trying to explain.

Regards

Aaron
 
Do you have join tables to link say the ClientId to ClinicID etc? If so, you can link the child/master fields of the main form and subforms, and then the info relating to the patient will appear correctly.
Sorry if this isn't much help ( I don't know your set-up or what you knowledge is) - post back with more details if you are still stuck. :)
 
Tay just beat me to what I was going to say - in addition I would suggest having the switchboard form seperate from the personal details form.

Then as Tay suggested, if the links are ok there shouldn't be a problem.

Col
 
Hi Lads,

Right what I will do is give you a look at the test database dont laugh it is a mess at the moment. I am greatful for your help

Can I mail it to you as it is too large to post
 

Users who are viewing this thread

Back
Top Bottom