I used the table analyzer to split my table into 3 parts.
date | custtype | custno | orderno | comments
custtype-has 12 recurring fields and it needs to be selected separetely from custno
custno-has duplicates also
I want to split it like this:
tb1 date|comments|LU to orderno|LU to custype|LU to custno
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. Relationships are all one to many and I let the the analyzer set the genuine key.
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!!
(Maybe I just don't understand how to use the forms and how to relate the tables)
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.