As yet, I've had no replies from anyone to my Access problems, so here I am, trying again!
I've got a query that has a one table in it, this displays various information based on the criteria plus there is a field in the table called RecID which is a child/parent linking field.
I have another table with 1 record only in it which basically stores what particular record set (based on RecID) we're working on for modifications to data.
The problem is that with the 1 table in the query, you can alter the data, but as soon as you introduce the other table into the query (regardless of whether you use any links or fields from the new table into the query) the data becomes un-editable.
What I'm trying to do is make the RecID look to the other non-linked table and check what the current record set is and use that number as the restricting data.
If I just use the one table, which allows me to edit the data, is there an SQL? lookup command to talk to the first record in the table that holds the restricting data? without having to actually add the table which seems to negate the alteration of the data retrieved?
I would REALLY like help on this, please, please, please. We've / I've got a lot of kids relying on this software for their sponsered triathalon.
I've got a query that has a one table in it, this displays various information based on the criteria plus there is a field in the table called RecID which is a child/parent linking field.
I have another table with 1 record only in it which basically stores what particular record set (based on RecID) we're working on for modifications to data.
The problem is that with the 1 table in the query, you can alter the data, but as soon as you introduce the other table into the query (regardless of whether you use any links or fields from the new table into the query) the data becomes un-editable.
What I'm trying to do is make the RecID look to the other non-linked table and check what the current record set is and use that number as the restricting data.
If I just use the one table, which allows me to edit the data, is there an SQL? lookup command to talk to the first record in the table that holds the restricting data? without having to actually add the table which seems to negate the alteration of the data retrieved?
I would REALLY like help on this, please, please, please. We've / I've got a lot of kids relying on this software for their sponsered triathalon.
