Multiple forms/single table?

[iamrah]

Hello friends,

I have a pretty noobish question. I was wondering if it was possible to have several (3 in my case) different forms that apply data to a single table?

The main table has three different types of data: 1. Client info 2. Services A 3.Services B. Each type of data has about 7/50/12 different fields of data in each set so that trying to include all this data on a single form is not very user friendly due to clutter.

I have three forms that input data into the table, however the record navigation command buttons that I have on the forms do not apply the data to the correct record. For instance, when I input the Client info for client #2, and click the "open services A form" command button, the form opens on client #1 Services A instead of to a new record.

Is this something I have done wrong, or is it due more to MS Access limitations?

Thanks

 

[antonyx]

are you saying you have 69 fields in one table..

and in one table you are storing info on clients.. and two types of services...

i might aswell say this.. are you sure you have normalised your tables.. do you know what that is??

 

[KeithG]

Sounds like you have a Normalization problem to me. You shouldn't be storing the client info and the sevices in one table. I would break the table into two tables clientinfo and services. Then I would create a one to many relationship from clientinfo to the service table. After that you can create a form for the client info and a subform on that form to display/add the services.

 

[iamrah]

You guys are right. I found out what normalization was after I started working on this database. I was hoping to work through this on my current db to see if I can get it to work, but I'm at the point of scrapping it, and starting all over.

I have a couple of questions on design, but I'll post it in that forum.

I'm pretty new to Access, but I'm learning alot in a fairly short amount of time thanks to this forum. Thanks anyway for the help....I'll be back.