1: Is the relationship between Designation and Establishment 1 to 1 or 1 to many?
Ans:1 to many
2: Is the relationship between Establishment and Structure 1 to or 1 to many?
Ans1 to 1
I have been able to add new information but now I encounter a new error "index or primary key cannot contain a null value" while every field in a form have been entered.
medube1
Last Activity: Sep 5 '13, 12:27 PM
Joined: Jul 18 '13
Location:
-
I want user's to add information within the form not manually on each table in datasheet view, this form is based on query with that combine 3 tables Establishment,D esignation and Structure table.
Firstly Post_id,Post_id Level,postgrade devired from Establishment, designation to Designation table and Cluster_Name,Un it_Name, Department_Name , Branch_Name, Division_Name,S ection_Name and Subsection_Name into the Structure table. That's...Leave a comment:
-
I can't add new record on a form
Greetings,
I have added an attachment to my problem so it will be easy to pin point what i have missed, i hope it will help...Leave a comment:
-
I can't add new record on a form
I can't add new record on a form, the add new record in navigation toolbar is disable on the form, but on properties I enable (addition,edit and delete)but still it's not working.
Please assist -
Thanks guys that help meLeave a comment:
-
filtering combobox and adding new records
Greetings,
Maybe this question has been asked before, I have a form that got couple of combobox.The first combobox must filter second, second to third so on, the form is based on a query from these tables(tbldesig nation, tblestablishmen t and tblstructure).
The other issue I have I can't add new record, the add new record in navigation toolbar is disable on the form properties I enable (addition,edit and delete)but still...
No activity results to display
Leave a comment: