Database Question

  • Thread starter Thread starter Aye Office 101
  • Start date Start date
A

Aye Office 101

I made a database concerning meeting times with clients. I have the Client
Info in one table and their Meeting times in another. The problem I am having
is that when I create a form, I know how to filter to make the all the
meetings for that client appear at once but if i meet with that client again
their client info doubles but the meeting portion if correct.

On the Form:
Tab1 is Client Info, Address, etc.
Tab2 is Meeting Time, Place, etc.

Record 1: John Doe - Meeting 1 @ 10 am on 6/7/05

Now if i want to add another meeting

John Doe's Client info comes up twice as another record so instead of one
record I have 2 but with the correct meetings.

Record 1: John Doe - Meeting 1 @ 10 am on 6/7/05
- Meeting 2 @ 10 am on 6/14/05

Record 2: John Doe - Meeting 1 @ 10 am on 6/7/05
- Meeting 2 @ 10 am on 6/14/05

I want it to be just for one record!!!!

Record 1: John Doe - Meeting 1 @ 10 am on 6/7/05
- Meeting 2 @ 10 am on 6/14/05
 
Aye Office 101 said:
I made a database concerning meeting times with clients. I have the Client
Info in one table and their Meeting times in another. The problem I am
having
is that when I create a form, I know how to filter to make the all the
meetings for that client appear at once but if i meet with that client
again
their client info doubles but the meeting portion if correct.

On the Form:
Tab1 is Client Info, Address, etc.
Tab2 is Meeting Time, Place, etc.

Record 1: John Doe - Meeting 1 @ 10 am on 6/7/05

Now if i want to add another meeting

John Doe's Client info comes up twice as another record so instead of one
record I have 2 but with the correct meetings.

Record 1: John Doe - Meeting 1 @ 10 am on 6/7/05
- Meeting 2 @ 10 am on 6/14/05

Record 2: John Doe - Meeting 1 @ 10 am on 6/7/05
- Meeting 2 @ 10 am on 6/14/05

I want it to be just for one record!!!!

Record 1: John Doe - Meeting 1 @ 10 am on 6/7/05
- Meeting 2 @ 10 am on 6/14/05
Click to expand...

You have a one-to-many relationship because each client can have many
appointments. Set up a one-to-many relationship and put a subform on your
main form.

Keith.
www.keithwilby.co.uk
 
Aye Office 101 said:
okay but will that allow me to keep the form i created?
Click to expand...

I don't see why not, you could use it as your main form onto which you'd
place your sub-form.
 
Mr. Wilby I understand what you are saying but its it possible for me send u
an email of what is going on. I did the subform but its still comin up as
another client.
 
Aye Office 101 said:
Mr. Wilby I understand what you are saying but its it possible for me send
u
an email of what is going on. I did the subform but its still comin up as
another client.
Click to expand...

Have a look at the example database that ships with Access ("Northwind"),
there are plenty of form/sub-form examples in there.

Keith.
 
Back
Top