Search results

  1. H

    Enforce referential integrity

    I have two simple tables: Tcustomers and Torders. I have related the CustomerID of Tcustomers to CustomerID in Torders. A one-to many relationship with Enforce Referential Integrity checked. And cascade update and cascade delete both checked. Now I should be unable to enter a new Order in...
  2. H

    Solved set value of a record field in a table based of the aggregate of another table

    I have a table of Products and a table of Packages. Each product has a serial number. Each 4 products are packed in 1 package. My product table has a Package field where I tell the database that each product goes to which package. There is a Yes/No field in Packages table that must be set...
  3. H

    simple question about combobox/textbox

    Hello everyone, I am new to access. I have a table with some fields. I created a form for that table in Add mode so that I can add records to the table. in the form I have a combo box with values I manually entered. suppose the values are "a" , "b", "c". I have set the control source of the...
Back
Top Bottom