Getting the value from the secondary field without relationship

[chadski021]

Is there a way to get the value from the another field without any relationship on another table

[Raybaudi]

Yes but only if that "another" field is global.

[comment]

Yes but only if that "another" field is global.

 

Actually, there are ways to get the value from a non-global field, too: for example, you could run a script or use ExecuteSQL(). Provided, of course, that you know which record in the other table to address.

 

 

@chadski021

It's much better to ask your question in the format of "I have << a short description of your solution >> and I am trying to  << explain what you need your solution to do >>" instead of "Is it possible to << some technical operation >>". 

 

Knowing the context and the purpose, one may answer "Yes, but it would be better to ... " or "No, but you could ... " rather than just yes or no.

[LaRetta]

You can use value lists many times.

 

For instance, if you have a StaffID in many tables, there is no need to create a relationship to the staff table for each of those relationships just to display the staff name.  If you have value list based upon all values, with id and name as second value and showing value only from second field, you can place pop-up menu where ever you want the staff name (turn off entry to the field).

[comment]

You can use value lists many times.

 

That's a good point. And maybe that's what OP meant by "the secondary field" mentioned in the title.

 

 

BTW, if you define a second value list to use values from the Name field, you can not only display the name, but also use it in calculations - see:

http://www.briandunning.com/cf/908

[chadski021]

This is my explanation :

 

I have Table the Name is User in this table all the names will be enter here

 

For example:

 

Fist Record

Account Field: 1st Account

Name Field:  Ana

 

Second Record

Account Field: 1st Account

Name Field: Karen

 

Third Record

Account Field: 2nd Account

Name Field: Nina

 

Fourth Record

Account Field: 2nd Account

Name Field: Yuna

 

Fifth Record

Account Field: 2nd Account

Name Field: Ren

 

Sixth Record

Account Field: 3rd Account

Name Field: Rara

 

In 1st Account we have Ana, Karen

In 2nd Account we have Nina, Yuan and Ren

In 3rd Account we have Rara

 

also i have 3 layout for 1st Account, 2nd Account and 3rd Account my problem is how can i filter or show the names with corresponding Account type in corresponding layout

in dropdownlist/pop up menu without relationship?

[comment]

So basically you are asking how to drive a car with no wheels?

[chadski021]

So basically you are asking how to drive a car with no wheels?

 

So it mean it's not possible?

[comment]

It's either impossible or very difficult, complicated and resource-intensive. I don't really care which. Look, this is ridiculous: relationships are a key tool of any relational database - some would say the most important one. Why would you want to deny yourself the benefits of using it? It just doesn't make any sense.
 

[Wim Decorte]

Very curious: why would not want to have any relationships?  As Comment indicates: they are crucial to any data architecture.  Over-use and connecting every TO to every other TO can lead to performance problems but with proper design there should not be any issue whatsoever to using a relationship where it is needed.