can't get my forms to work

[Scott Crivelli]

I used the table analyzer to split my table into 3 parts.
example.
original table
date custtype custno orderno comments

custtype-has 12 recurring fields and it needs to be
selected separetely from custno
custno-has duplicates also
orderno-no dups
comments-memo

I want to split it like this:

tb1 date|comments|LU to orderno|LU to custype|LU to custno
tb2 orderno
tb3 custtype (lookup in the custno table)
tb4 custno|LU to custtype

When I use the analyze tables option, I successfully
split the DB into these parts. When I check the links in
the tables they are good.

The problem occurs when I try to turn this mess into a
form. When I use the wizard, I take the date and
comments field from tb1, the orderno from tb2, custtype
from tb3 and custno from tb4. All is good until I have
to pick "view by". I believe that something happens at
this point because when I try to update the records,
whichever option I choose to view by, I am unable to
update the text boxes. I get that godforsaken BEEP!!

As I enter in order numbers, I also want to add new
custtype/custno as they occur without having to have 4
different forms. And to further complicate matters,
There is a main custno table that will holds all my
customers even if they don't have any orders this year.
Any new entrys would also need to go into that table but
I think I can work that with a query.

Also, How do you NOT limit a combo box when you split the
tables using the analyzer. custtype may need to be added
to and I dont' want to lock myself out of it.

Help me please... I am going gray!!!

Scott

 

[Gina]

I believe your first problem lies in trying to update a query that is tied
to a one-to-many relationships. You cannot update the, in the query, the
many side because the one side cannot take on additional data without a
primary key, hence the BEEP!

Suggestion create a subform based on the table you want to add to allowing
data entry to that table. Create an additional form, perhaps accessed by a
button, to allow entering of new customers. And finally, there is a
selection in the table when setting up fields, ie. custtype, not to limit
the data entered in any particular field.

Hope that saves some of your hairs!