Results 1 to 5 of 5
  1. #1
    Join Date
    Sep 2003
    Posts
    18

    Unanswered: trouble with linking forms to tables

    I am very novice...


    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. 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.

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

    Scott

  2. #2
    Join Date
    Sep 2003
    Location
    Michigan
    Posts
    2
    part one: are you using a sub-form for your one-to-many?

  3. #3
    Join Date
    Sep 2003
    Posts
    18
    Originally posted by kalyhi
    part one: are you using a sub-form for your one-to-many?
    No, I tried it but it wouldn't match up the old data between the form and the subform.

    I used the table analyzer to split the tables and then created the form like i described.

    I am making a copy of the DB (minus the records) so you can get a feel for what I need...should be ready shortly

  4. #4
    Join Date
    Sep 2003
    Posts
    18

    attached sample db

    Attached is a copy of the DB as it is now (without the records)

    If anyone can show me how to connect these tables properly and have a form that fills the tables I would be very appreciative.

    The ORDER NO table is the basis for the user input.

    The CUSTOMER NO TABLE is the main link between the three Main tables... ORDER NO, CUSTOMER INFO, SALES.

    The customer numbers have different instances in each main table yet only one instance in the CUSTOMER NO TABLE.

    The CUSTOMER TYPE table goes hand in hand with the CUSTOMER NO table.

    Thats all I can think of now
    Attached Files Attached Files

  5. #5
    Join Date
    Sep 2003
    Location
    Michigan
    Posts
    2

    sub-form

    northwind.mdb sample db probably does it best.
    I located it in C:\Program Files\Microsoft Office\Office\Samples

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •