Galaxiom,
I am not sure that my tone came accross as I had intended. I was not arguing that my way is better, simply clarifying the structure of the db that I have been given. I know "my" way is not better that is why I am here. I do appreciate the time and thought that you put into your...
Galaxiom,
"CTVELISA and LEPROELISA tables should be merged and another field added to indicate whatever those names mean."
CTVELISA and LEPROELISA are descriptors used in biology and their meaning is understood by those who use the database
the location table is setup in the most efficient...
Thank you Galaxiom,
This is my first venture into Access. I have C++ knowledge, but the SQL syntax is new to me. I have been given a db that is atrocious and I am working from the ground up.
Your ideas on the structure are logical improvements. Thank you!:D
I will be implementing some changes...
I would just prefer to be able to do this. I would like to know if I can even use a form to update more than one table --> i.e. properties/source data.
There is no relationship between the tables, but they are both indeterminately linked to another table.
Need to ask a couple of...
I have run into the issue of a "recordset" not being "updateable". I am running Access 2007.
My issue is that I have a query that is pulling data from two tables using a union statement. I have built a form that I would like to be able to use to update those tables.
I have heard that I may...