Form Help.....

A

amorrison2006

Hi

I am hoping someone can help.

What I want to do is have my forms show up with a drop down box
showing my client names and then when I select my client the form
should show all my accounts for that client.

I do not know how to do this or whether this should be done from my
table.

I hope someone can help.

Thanks so much,

Andrea
 
A

amorrison2006

Hi Steve

I have one table which I plan to expand as my database become more
advanced.

The fields in my table are Client, Account, Date1, Date2, Date3,
Amount.

I want a form to filter down to show only the records relating to my
client.

I am also going to try and make the window refresh so it can update as
I will have multiple users accessing it. I appreciate your help with
this,

I hope you can help with the drop down list so it only shows records
for one client say "Funky Doughnuts" and then all the accounts which
relate to "Funky Doughnuts".

I hope I make sense to you,

Thanks so much,

Andrea
 
S

Steve

Andrea,

Your table is incorrect! That's the root cause of your problem. You need
more tables in your database immediately. Please explain what all your
fields mean and I will give you a recommendation for the tables you need.

PC Datasheet
Providing Customers A Resource For Help With Access, Excel And Word
Applications
[email protected]
 
A

amorrison2006

Hi Steve,

Thank you for coming back to me,

It's much appreciated,

I will tell you what I am doing with this database.

I have hundreds of clients for example. Each client has a name. I
was thinking of keeping them in a separate table...??

Each client then has multiple accounts. Some could have one, other
could have 100's.

Within each account I want to track the dates of my letters sent to
them......

I would like the form to be in a tablular view to make it easy to see
for me and my staff.

I would prefer to have one form and then right at the top of the form
have a filter which allows me to filter down to my clients and show me
only that clients orders.

If I could also have an "All" filter to show me everything that would
be great. I am so silly with these databases but I have seen them
help alot in the past.

I then want to add additional functionality to it for example sending
out emails when my clients havent responsed to me.......I think the
first thing is to get my database structure correct.

Can you help me??? Please.....

Perhaps you could send me an example file to my email......

I would be every so grateful. I do everything manually at the moment
for my small business and I am starting to lose track of everything.

Thank you Steve,

Andrea
 
Top