In this database attached I have a form called:
I have been able to make all the fields to do as I want except for “Tool ID” which I want to show the primary key number from table “tblToolNames”.
When I select text field to place on the form I don’t see a way in the properties dialog box to select an option to make the primary key for “tblToolNames” so that it will show in the form.
In live view all fields are “Unbound” except for “Type of Device” why I don’t know. I have also tried to enter values for “Type of Device” in the table “tblTools”.
I am trying to load in data to begin using the database and I get the following: “You cannot add or change a record because a related record is required in ‘tblInspections’. I kinda understand what is going on but I need to load up some data to start things off like the instruments names, type of device, and brand these field values will only contain a number of different values that will apply to the field below which will always be different from the fields above.
What am I doing wrong??