Information within a table

[myogenesis]

i am trying to create a form with a sub-form in it. i have got my client details in it - address, phone, etc then within that table i would like to keep a track of treatments for each time they visit in decending order. can anyone help me out with this? hope someone understands what i mean

 

[ColinEssex]

I think you're describing a normal one-to-many relationship.

One client can have many visits. . . however

one visit could (possibly) have many treatments. So you should have a table for clients, a table for visits and a table for treatments related to the visit.

Sort out the relationships via Tools>>>>>>>Relationships and then you're away.

Col

 

[pafcpilgrim]

to complete it type the field name in the order by of the sub form to get them sorted how you want.

Plus - when you add your sub forms don't forget to link the primary key to it's children in the other tables so that when you add visits and treatments the records all relate to the customer if you use the wizzard it will do this for you.

 

[myogenesis]

thank you

thanks for the advice guys - got it sorted