Recent content by Argi

  1. A

    Setting up proper relationships

    I Think i am understanding how this is suposed to work, please see attached adn comment. I think it is more organized and you are completely right, 1 to 1's were doing nothing. ANy more pointers on the layout? Or anything else?
  2. A

    Updating Form Fields From Table

    Here is some more, just in case cant open
  3. A

    Setting up proper relationships

    ISSkint no i never considered anything as i have little knowledge on available options. I never imagined displaying data from diffirent tables on the same form would be such a problem for me. I always thouhgt it was as simple as choosing the filed from the other table and entring into the form...
  4. A

    Updating Form Fields From Table

    Yes i can but form will not work on import, please see attached. Also not sure fi relationships are done properly.
  5. A

    Setting up proper relationships

    Isskint after a bit of research i figure out a way to 2003 the 2010 DB however fomr did not import so i assume it has the problem with the save as as it was not working. I looked it over and tables seem to be all the same. Please try to open this one. Let me know, thanks.
  6. A

    Updating Form Fields From Table

    What happened to my support team :) . Did everyone lose interest already? Is there somethign wrong?
  7. A

    Setting up proper relationships

    What happened to my support team :) . Did everyone lose interest already? Is there somethign wrong?
  8. A

    Setting up proper relationships

    Here is update with relationships, any adivse appreciated. Thanks.
  9. A

    Updating Form Fields From Table

    This is update with relationships that i think may be right. Any opiniond is appreciated.
  10. A

    Updating Form Fields From Table

    THis is update DB file.
  11. A

    Setting up proper relationships

    This is the updated DB file. Please ignore last one
  12. A

    Setting up proper relationships

    Pat im starting to get it, makes sense on the cascade. Also thaks for the point on embeddded spaces and characters, i have made most of those changes already, just need to do the special characters now as i missed it during first read. About the golf ball example i need to ask you for...
  13. A

    Updating Form Fields From Table

    Isskint i have attached the BD, i feel it would take much less of your time looking at it instead of having me ask you several more questions. I counld not find a duplicate text box but there is a combo box and a filed with same data in them, combo just shows were field has written data from...
  14. A

    Updating Form Fields From Table

    I created a new text field and left the default name Text234 or something like that. I used the second versions of DLOOKUP namely =DLookUp("[Case Gross Weight (Kg)]","[Item List]","[ITEMNO]=" & [me].[ItemNo]) and still got the same error. Any ideas?
  15. A

    Updating Form Fields From Table

    I get a #Name? showing up in the field. This si what i tried =DLookUp("[Item List]![Case Gross Weight (Kg)]","[Item List]","[Item List]![ITEMNO]=" & [me].[ItemNo]) I also tried this first =DLookUp("[Case Gross Weight (Kg)]","[Item List]","[ITEMNO]=" & [me].[ItemNo]) and get the same...
Back
Top Bottom