Hi,

I have got a very simple select query that is listing all fields from a table using the "*".

Why won't it allow me to add records at the bottom please?

Other select queries I have allow me to do this.

Many Thanks

Does the query pull from multiple tables? If so, you need to make sure your relationships (joins) are set up correctly (Primary Key - Foreign Key).

If you need more assistance, please post your SQL.

Yes, actually there is another table involved.

In tblData there is a field called "Ward"

The list of wards comes from tblWards, which also has other fields about the ward.

Should I make the field called ' Ward'in tblWard (the lookup table) the primary key?

Thanks

Every Table must have a primary key.

Suggested Readings & Things

Thanks for your helpl, the primary key has made it work.

You are welcome.