Solved How do I add a calculated management field and how do I add the name instead of the number

[Sarah.M]

Hi, Plz note, My VBA is disabled at work for security reason
I can use only Expression builder, Macros, Queries, Tables, Forms and Reports only.
1. How do I add a calculated management field (I mean Field that is not part of the table just to be shown in table)
2. how do I add the name instead of the number

Sample database has been attached
plz help!

 

[MajP]

GET RID of ALL table lookups!!!

The Access Web - The Evils of Lookup Fields in Tables

Then in the query for the combo join to the managment table and pull in that field not the management field from the Section table

 

[arnelgp]

you create a Query (see qryUserSection) and use the query as recordsource of your subform.
actually there is "No Evil" in them if you know how to tame them.

 

[MajP]

?

 

[arnelgp]

here is the fix:

 

[MajP]

That is the same as what I suggested.

 

[arnelgp]

there is an alternative dlookup()?

 

[Sarah.M]

there is an alternative dlookup()?

Please!
show me that, i think this is what I am looking for

 

[arnelgp]

as per your request, this is the SQL of your Section combobox's rowsource:

select sectionT.id, sectionT.section, DLookup("Management", "managementT","ID = " & sectionT.[management]) As Mgmt from sectionT;


this is only alternative and nobody will suggests this.
the rowsource of Section has already a Joined tables.
see the attached file above.

 

[Sarah.M]

as per your request, this is the SQL of your Section combobox's rowsource:

select sectionT.id, sectionT.section, DLookup("Management", "managementT","ID = " & sectionT.[management]) As Mgmt from sectionT;


this is only alternative and nobody will suggests this.
the rowsource of Section has already a Joined tables.
see the attached file above.

Thanks!
I will try it soon once I get back at home

 

[MajP]

Really?

 

[Sarah.M]

as per your request, this is the SQL of your Section combobox's rowsource:

select sectionT.id, sectionT.section, DLookup("Management", "managementT","ID = " & sectionT.[management]) As Mgmt from sectionT;


this is only alternative and nobody will suggests this.
the rowsource of Section has already a Joined tables.
see the attached file above.

Thanks I like it, can we put it in Query to make as Filed? plz see the picture

 

[arnelgp]

did you see qryUserSection on the db i uploaded.
view it in design view.
then make it the Recordsource of your subform.

that one is much simpler than:

Management: DLookUp("management","managementT","id= " & DLookUp("management","sectionT","id=" & [section]))

 

[Sarah.M]

did you see qryUserSection on the db i uploaded.
view it in design view.
then make it the Recordsource of your subform.

that one is much simpler than:

Management: DLookUp("management","managementT","id= " & DLookUp("management","sectionT","id=" & [section]))

Ohhh, yes Thanks!!!
This is what I am looking for!!!