show name in a combo box but store id

[alvesi]

DO NOT USE LOOKUP FIELDS ON TABLES.
Use a query for the combos with ID, description. You store the iD, and show the description.

From a simple Google

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 when we put a query together, it will run and will creat some kind of snapshot of that combination which can not be dynamically modified but is rather static.
On this way, what would be the alternative ?

Cheers
Isac

 

[Minty]

The query is no more static than a table view. Both are only accurate when you either open it or refresh it.
Lookups in tables create a false sense of "easy programming" but generally achieve the exact opposite.
Have a read here

The Access Web - The Evils of Lookup Fields in Tables

access.mvps.org

The method Gasman describes is the correct way to achieve your goal.

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.

 

[alvesi]

The query is no more static than a table view. Both are only accurate when you either open it or refresh it.
Lookups in tables create a false sense of "easy programming" but generally achieve the exact opposite.
Have a read here
The method Gasman describes is the correct way to achieve your goal.

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.

Hi Minty

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

 

[alvesi]

The query is no more static than a table view. Both are only accurate when you either open it or refresh it.
Lookups in tables create a false sense of "easy programming" but generally achieve the exact opposite.
Have a read here

The Access Web - The Evils of Lookup Fields in Tables

access.mvps.org

The method Gasman describes is the correct way to achieve your goal.

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.

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

Cheers
Isac

 

[alvesi]

PS, I'm hoping your actual column names are better than what you posted. Because you are using Lookup fields, I'm pretty sure that your relationships are not correct either. It is only confusing to use "ID" as the PK name for each table instead of giving the PK a real name. They could be SourceID, CrossRefID, ScenarioID, ResourcesID. Then the FK should use the same name or if that confuses you, use the PK name with "_FK" as a suffix.

Thanks Pat, it helped really a lot!

 

[strive4peace]

hi @alvesi

re: "when I use the look up combo box on the table to select the “name text” it only show me the “id number”"

You can fix that by setting the ColumnCount, ColumnWidths, and ListWidth properties

Here's a short video to explain it:
Combo Box properties in Microsoft Access (11:25)