Martin has attended:
Access VBA course
SQL Server course
Updating a table that has primary keys in it
Hi,
I have a database with several tables in it each linked by not one but five (5) fields that form a primary key. The normal way of inputing data is via a form but I have 150 records to add and I have all the data in an excel spreadsheet so would like to do a bulk add and update.
All the data I want to add is to a single table that has all the keys contained within it. I have tried importing the data to the table and this works, in that I can see the additional data in the table. However, when I look at the data via the form I don't see the new records.
Any help would be much apreciated.
Regards
Martin
RE: Updating a table that has primary keys in it
Hi Martin
Sounds a bit of a puzzle. If the data gets imported into your table it should appear in your form. Would you be able to email your database to info@stl-training.co.uk ?
Best to zip the file and ask for it to be forwarded to me.
Thanks.
Regards
Doug Dunn
Best STL
RE: Updating a table that has primary keys in it
After several attempts I have managed to write an update query that not only updates the primary table but also its linked table that also has all five primary fields in it.
Little convoluted but can see why I needed to it this way.
A good learning session.
Thanks
Martin
RE: Updating a table that has primary keys in it
Well done.
Sounds like you have solved it!
Doug
Best STL
