the add new record is disabled

[medube1]

Greetings,

I am new to this forum, i have a form frmestablishment the problem i can't add new record(new record is disabled on navigation toolbar) in my form properties allow eddition is set to YES but still i have no luck in form view for add new record. The other part is that my form is based on a query in the query you can add new record.

i hope my explanation is clear, please assist.

Signor

[June7]

If you want to provide db for analysis, follow instructions at bottom of my post.

[medube1]

If you want to provide db for analysis, follow instructions at bottom of my post.

Greetings,

i have added an attachment to my problem so that it will be easy to pin point my problem, i hope i will help

[June7]

This is a first for me - a 7-field compound key. The table joins in Relationship builder are messed up. I tried to fix and it insists on doubling the Structure table

Why are the comboboxes all unbound?

This is odd. The DataEntry property is Yes so this means should not be able to view existing records and should be able to only add new records. I think the issue is the query. Note that there are 32,180 records in Establishment but only 29,092 in the query because of the type of joins. Don't include Structure and Designation tables in the query. Could just bind the form directly to Establishment.

[medube1]

This is a first for me - a 7-field compound key. The table joins in Relationship builder are messed up. I tried to fix and it insists on doubling the Structure table

Why are the comboboxes all unbound?

This is odd. The DataEntry property is Yes so this means should not be able to view existing records and should be able to only add new records. I think the issue is the query. Note that there are 32,180 records in Establishment but only 29,092 in the query because of the type of joins. Don't include Structure and Designation tables in the query. Could just bind the form directly to Establishment.

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,Designation
and Structure table. Firstly post_id,post_idlevel,postgrade devired from Establishment
designation to designation table and cluster_name,unit_name, dept_name, branch_name, division_name,
section_name and subsection_name into the Structure table. That's the only information that the user I want to add

I hope this will help.

[June7]

I did not suggest editing directly in tables. Use form but don't include Structure and Designation in the RecordSource. A form can enter/edit data to only one table.

[medube1]

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.

[June7]

Why are there two ID fields in Establishment with identical values, except one is text and one is number?

Don't understand why error. I can enter new record in form after the change to RecordSource I described.

[medube1]

Why are there two ID fields in Establishment with identical values, except one is text and one is number?

Don't understand why error. I can enter new record in form after the change to RecordSource I described.

The Post_id is number PK and Post_idLevel is text PK(it can also contain characters).

[June7]

I know one is number and one is text, I just don't understand why you have both.

I still don't get error.