Recent content by alvesi

Thanks Pat, it helped really a lot!

Hi Minty Especially your last comment "A form displaying what you need would use the lookup table as a source for a combo and the form/ query should be completely editable." Just made all difference and I could understand Gasman proposition. And solve my problem. Challenges of being a total...

Hi Mike60Smart, Was my lack of experience. I though cutting out the fat would facilitate the general understanding but then, by all questions, I saw it was the opposite.

Thank you Jdraw, you are right, and that's the right approach I shall adopt.

Thank you very much LarryE, I'll add this rational to my structure.

Hi Minty Thank you. I’ll also try this configuration you mentioned and will inform how it went through. Cheers isac

Hi Gasman Thank you for your reply. Please, correct if I am wrong, but the query will be a rather static view of a combination of data, right? I use tables as I do need to store each of the combinations and play with that changing and adapting combinations all the time. i understand that...

Hi Strive4Peace Sorry about my delay to reply, it is the time zone diference. As I am not skilled in MS Access, I might have not explained myself sufficiently clear. Below I am adding an example. On table SOURCES I enter the “Data 1a”. On table CROSS-REFERENCE I have a look up combo box...

Hi Strive4peace, I used your recommendation on a form and it worked very well. Is there a similar parameter configuration for a look up on a table? I am getting the same issue, only can see the “ID number” and I only need to see the “text name” thank ypu for your reply Isac

Hey Mike60Smart, You are right. And "Data 1a" is compatible with the person's name and will go up on the chain. It is the main reference data. All the others are additions here and there. Hope it clarifies. Cheers Iac

Hi Jdraw, sure, but as I am still developing the rational and testing it, I don have yet real data employed. But I can tell you how it will be used. Purpose: This is a data-base to support writing a thesis on immigration patterns. Source: Names, Family Names, Locations Cross-Reference...

Hi theDBguy, Thank you! I am happy to do so. My only problem is how to implement it. My first question would be, using query will I be able to see the "name text" and not be forced to see the "id number"? The second question would be, that immigration patterns are far from being an exact...

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...