I have a query that I am running based off two tables. To one of the tables I add a few blank fields as my boss wants me to calculate the accounting portion. I work at an budgets unit but as IT. Anyways, I ran the query and opened it in a form for the Analyst to input their numbers. So every other field is calculated. A + B = C. I have something in field A and I am putting the input in field B to get teh results in field C. So that's say that I queried for a certain analyst and I get four records. When I input anything into first record the input is in all the records for field B. This is where I am having a problem. I only want to input into the the correrdponding record and not all the records I query. Any ideas?
Repeating Input in all the Query records
- Thread starter Jass7869
- Start date
Take a backup/copy of your database to work on. Copy the linked table into your database.
Drop connection to the linked table and rename the the copied table to the name of the linked table.
Remove/delete all queries/tables/forms/module that isn't necessary for running the form in which you've problem.
Then zip and attached it to here.
A question: Do you need to save the input in field B (+ the calculated value)?
It's not allowing me to upload my DB and yes I need to save Field B input into the first orginal table (One of the two tables being used for the query). I know I have a problem with my query..as once I run it I try to edit and it's not allowing any edits:banghead:
Hello JHB,
The field that I am having issues with is BC1_Change..1-4 even though I don't have all of them on the form yet...working with one at a time.
Please let me know what you think...I still have not been able to figure out why I can't enter data into those fields. Name of the frm is Final_frm
The field that I am having issues with is BC1_Change..1-4 even though I don't have all of them on the form yet...working with one at a time.
Please let me know what you think...I still have not been able to figure out why I can't enter data into those fields. Name of the frm is Final_frm
The problem you've is that value for the linked fields aren't unique.
Let's take some sample.
As you see, both record with the ID 1275 and 1276, (Final_Table), points to the same records with the OrgLookId 705 and 707, until you get that in place, (only one record in the main table point to one or more records in the sub table), you're not able to do what you want.
Let's take some sample.
As you see, both record with the ID 1275 and 1276, (Final_Table), points to the same records with the OrgLookId 705 and 707, until you get that in place, (only one record in the main table point to one or more records in the sub table), you're not able to do what you want.
Attachments
Sorry - I can't tell you, then you are the best to decide what you want now!
Because you know from where the data are coming and why a good part of same data are stored in two tables.
The basics of databases is only a save data only in one field in one table and not like what you have here, the same data to multiple tables.
But you can't link tables together and edit/add data to them if MS-Access isn't able to put the data in a unique record, at least not in the way you want it.
Hello,
I told my boss the data should be in one table for uniquiness. But the OrgLook table is used in several other DB and she wants to be able to save the user input into the final table. This DB is getting to be a headache and I am not an expert.
I told my boss the data should be in one table for uniquiness. But the OrgLook table is used in several other DB and she wants to be able to save the user input into the final table. This DB is getting to be a headache and I am not an expert.
Similar threads
