Page 2 of 2 FirstFirst 12
Results 16 to 19 of 19
  1. #16
    Join Date
    Apr 2017
    Posts
    1,673
    Integer value needs 2 bytes of memory per field. An unicode text field needs (I think) 2 bytes per defined character length for field. So all interactions (especially indexing) with text fields take more time. It would be not obvious with really small databases, or in case the number of text type foreign keys used in tables is really small, but otherwise this will cause a huge drop in DB performance.



    Another bonus of using pairs on numeric id and text name defined in table is, that you can at any time change any of those names in this table, and you get the new name displayed instead of old one everywhere, without any additional changes to your DB.

  2. #17
    Thim is offline Novice
    Windows 10 Access 2016
    Join Date
    Nov 2022
    Posts
    9
    Maybe I would beter start a new tread. But I think it is more clear when I continu here.
    i make it short.
    tblType(AssetType) with value TypeA, TypeB
    tblPropertie(AssetProp) with value PropA, PropB
    tblCombination(AssetProp, AssetType) with record propA,TypeA and record propB, TypeA
    tblPropValue(TagNr, AssetProp, PropValue) with record x1, propA, 10 and record x1, propB, 15
    When I translate this in a from. I succeed to make a qry and filter out the TagNr.
    But I dont succeed to get the value in the correct field in the form.
    i tried sql with following code.
    select tblPropValue.PropValue,
    From tblPropValue
    Where tblPropValue.AssetProp =“PropA”
    But this doesnt seem to work.
    Anyone any idea?

  3. #18
    Join Date
    May 2018
    Location
    Living in Scotland UK
    Posts
    1,557
    It would help if you uploaded your Database
    You can PM me if you need further help.
    Good Reading https://docs.microsoft.com/en-gb/off...on-description

  4. #19
    Thim is offline Novice
    Windows 10 Access 2016
    Join Date
    Nov 2022
    Posts
    9
    Quote Originally Posted by mike60smart View Post
    It would help if you uploaded your Database
    Thx for the reply.
    I got it working with DLookUp.

Page 2 of 2 FirstFirst 12
Please reply to this thread with any new information or opinions.

Similar Threads

  1. Replies: 1
    Last Post: 11-25-2021, 06:28 AM
  2. Add value depending on Calculated
    By Almeidowski in forum Programming
    Replies: 3
    Last Post: 05-07-2019, 02:39 PM
  3. Create a ComboBox depending from another
    By SaPires in forum Access
    Replies: 2
    Last Post: 06-03-2014, 07:42 AM
  4. Replies: 3
    Last Post: 01-08-2014, 06:37 PM
  5. change a combobox value depending on another
    By emadaldin in forum Access
    Replies: 3
    Last Post: 01-17-2011, 01:06 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums