Search results

  1. S

    Hi Everyone

    Hi Alan :)
  2. S

    Hello from London, UK!

    Hi Harry :)
  3. S

    "You can't assign a value to this object" Error Message

    Oh I see! Thank you so much :D
  4. S

    "You can't assign a value to this object" Error Message

    Book ID is a foreign key is tblSeries. tblSeries is a sub form in a form containing the fields from tblBook. On the Office website it says "Use the Long Integer data type when you create a foreign key to relate a field to another table's AutoNumber primary key field"...
  5. S

    "You can't assign a value to this object" Error Message

    Thank you for your reply. The primary key is AutoNumber and the foreign key is Number with the Long Integer type. I think those two data types are compatible?
  6. S

    "You can't assign a value to this object" Error Message

    Hello, I'm building a simple database for storing records about books. I'm currently working on one of the data entry forms. Part of this form is supposed to enable the user to add details about the book and the series that it belongs to (if it does belong to one). The relationship is...
Top Bottom