Page 2 of 2 FirstFirst 12
Results 16 to 19 of 19
  1. #16
    BADebbie is offline Advanced Beginner
    Windows 8 Access 2010 64bit
    Join Date
    Jul 2015
    Posts
    33

    DB - I hope.

    I think I got it.
    Attached Files Attached Files

  2. #17
    ssanfu is offline Master of Nothing
    Windows XP Access 2010 32bit
    Join Date
    Sep 2010
    Location
    Anchorage, Alaska, USA
    Posts
    9,664
    OK, so I had to make quite a few changes.

    In "Part Orders small_MOD.accdb", there were reserved word used as field names (Date, Description) and there were spaces and special characters in field names; I renamed the fields. I also took out the spaces in other object names (tables/forms).

    I changed the record source for the form.

    The relationship between table "Equiptment" and "PartsOrder" had different data entered, so RI could not be enforced.
    Click image for larger version. 

Name:	Relationship1.jpg 
Views:	10 
Size:	38.4 KB 
ID:	29166
    Click image for larger version. 

Name:	data1.jpg 
Views:	10 
Size:	68.9 KB 
ID:	29167

    On the entry form, the combo boxes are working....



    In the Zip, there is a 2nd dB, "Part Orders small_Relationships.accdb". I don't like having a text field as a PK field, so in this dB, I changed the linking fields. If I were developing a dB, this is the one I would use.
    Attached Files Attached Files

  3. #18
    BADebbie is offline Advanced Beginner
    Windows 8 Access 2010 64bit
    Join Date
    Jul 2015
    Posts
    33
    In the form, I can't get it to do what you did with the PartID_FK. When I enter the part number it won't populate the Part Order table. In my combobox, PartID_FK won't come up as an option in the Control Source.

  4. #19
    ssanfu is offline Master of Nothing
    Windows XP Access 2010 32bit
    Join Date
    Sep 2010
    Location
    Anchorage, Alaska, USA
    Posts
    9,664
    In my combobox, PartID_FK won't come up as an option in the Control Source.
    Not sure I understand what you mean... You want to select a part in the combo box by a part number instead of description???? Or you want to see both?
    "PartID_FK" is an autonumber and shouldn't be visible to users. If you have Part numbers, would need another field.

    Autonumbers--What they are NOT and What They Are
    http://www.utteraccess.com/wiki/Autonumbers

    Microsoft Access Tables: Primary Key Tips and Techniques
    http://www.fmsinc.com/free/newtips/primarykey.asp



    Oops, just saw that the fields "OrderDate", "DueDate" and "RecvdDate" should be Date/Time field types in table "PartsOrder". Then you have access to the date picker.

Page 2 of 2 FirstFirst 12
Please reply to this thread with any new information or opinions.

Similar Threads

  1. Replies: 7
    Last Post: 10-13-2016, 12:32 PM
  2. Replies: 8
    Last Post: 04-23-2015, 08:36 PM
  3. Replies: 3
    Last Post: 02-25-2015, 04:48 PM
  4. Replies: 2
    Last Post: 12-04-2013, 05:38 PM
  5. Replies: 3
    Last Post: 10-03-2011, 02:33 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums