Hello everyone,
I have a challenge to build, manipulate and display cross-reference data. I may not use the right terminologies as I am not proficient in Access, but I'll try to explain myself. Any doubts just ask me to clarify.
Essentially, I have multiple sources of data. I need to organize them in multiple cross-reference possibilities. Then to create multiple usage scenarios aggregating other sources of data at this final stage. And I need to be able to create reports at any step of the process.
Scenario 1: The look up on a table. It is useful as I can easily recognize information by its "name text". But it only works at the first time I cross reference the data. After the source data has been combined on a second table. I then need to select this data combination - via look up again - but now in a third table. But this time I can only see the ID Number and no longer the "name text". How can I resolve that? Or workaround that?
Scenario 2: The combo box in forms. But the same occurs right from the first atempt to combine the data. I can only see the "ID Number" and not the "Name Text". How can I resolve that? Or workaround that?
On both scenarios I end-up having the "name text" replaced by the "ID Number". Nothing against, I understand the importance. But as a matter of fact, while the "ID Number" is very important, it becomes a nightmare to work as above described. I do not want to get rid of the ID but I do need to be able to read the "name text".
Below I send a small display of what I am trying to achieve.
Source: Provide the data
Cross-Reference: Creates multiple data combinations also adding extra data on top.
Scenario Builder: Creates multiple scenarios vs multiple data combinations adding extra data on top from itself and from the "Resources".
As you see, "Data 1a" from "Source" gets combined in the "Cross-Reference" and is manipulated in the "Scenario Builder" which is another data combination.
Scenario 1 - look up table: I have the "name text" up to "Cross-Reference" but it turns into "ID Number" in "Scenario Builder".
Scenario 2 - combo box: I get "ID Number" in "Cross-Reference".
How can I resolve that? Or workaround that?
Thank you in advance for your support.
Regards, Isac
I have a challenge to build, manipulate and display cross-reference data. I may not use the right terminologies as I am not proficient in Access, but I'll try to explain myself. Any doubts just ask me to clarify.
Essentially, I have multiple sources of data. I need to organize them in multiple cross-reference possibilities. Then to create multiple usage scenarios aggregating other sources of data at this final stage. And I need to be able to create reports at any step of the process.
Scenario 1: The look up on a table. It is useful as I can easily recognize information by its "name text". But it only works at the first time I cross reference the data. After the source data has been combined on a second table. I then need to select this data combination - via look up again - but now in a third table. But this time I can only see the ID Number and no longer the "name text". How can I resolve that? Or workaround that?
Scenario 2: The combo box in forms. But the same occurs right from the first atempt to combine the data. I can only see the "ID Number" and not the "Name Text". How can I resolve that? Or workaround that?
On both scenarios I end-up having the "name text" replaced by the "ID Number". Nothing against, I understand the importance. But as a matter of fact, while the "ID Number" is very important, it becomes a nightmare to work as above described. I do not want to get rid of the ID but I do need to be able to read the "name text".
Below I send a small display of what I am trying to achieve.
Source: Provide the data
Cross-Reference: Creates multiple data combinations also adding extra data on top.
Scenario Builder: Creates multiple scenarios vs multiple data combinations adding extra data on top from itself and from the "Resources".
As you see, "Data 1a" from "Source" gets combined in the "Cross-Reference" and is manipulated in the "Scenario Builder" which is another data combination.
Scenario 1 - look up table: I have the "name text" up to "Cross-Reference" but it turns into "ID Number" in "Scenario Builder".
Scenario 2 - combo box: I get "ID Number" in "Cross-Reference".
How can I resolve that? Or workaround that?
Thank you in advance for your support.
Regards, Isac