Aug 24 2005, 10:11 AM
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.
Aug 24 2005, 10:15 AM
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.
Aug 24 2005, 10:20 AM
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?
Aug 24 2005, 10:53 AM
Every Table must have a primary key. Suggested Readings & Things
Aug 25 2005, 08:55 AM
Thanks for your helpl, the primary key has made it work.
Aug 25 2005, 10:10 AM
You are welcome.
This is a "lo-fi" version of our main content. To view the full version with more information, formatting and images, please click here